#8

I’ve had this before and highlighted / clicked bold / unclicked bold. Also (bizarrely) changed the column width to correct it.
Otherwise, I’m out

#9

yes sorry as clarified above the issue isn’t the actual numbers it’s the way the font is rendering on excel with a strange bold effect on some of the numbers

1 Like
#10

doesn’t fix it unfortunately. thanks though.

It doesn’t seem to be a formatting issue, but more something either in excel’s settings or a computer display setting that Excel doesn’t like

#12

Are the figs from a pivot?

#13

Mine does this sometimes. It’s a problem with how Windows is displaying stuff rather than Excel itself. Closing Excel, then rebooting the computer always fixes it.

1 Like
#14

Dunno if it’s tge same thing but excel will go visually weird when low on memory, like it won’t show the result of a formula but the formula itself and then resizing a column will stretch and distort it like it’s a picture

#15

I’ve tested it with other sheets and the formatting issue seems to be on Calibri 11. If you size up or down it goes away and arial renders ok as well.

1 Like
#16

I’ll give a reboot a try and see if there are any updates that I need to install. thanks everyone for your help so far

#17

How much do you love Calibri 11…?

#18

Has it been zoomed in/out to a size that means it can’t decide if the numbers should be 1px wide or 2?

#19

ahh fixed it. had to turn on and tune Cleartype settings in Windows.

Thanks everyone for your help!

3 Likes
#20

Hi. This is probably really simple - I have a spreadsheet with different tabs called January, February and so on. I have a summary tab with the months as column headers. I want a formula to return a specific result from each tab - for example, if I want column X rows 2-12 from the January tab to go into rows 2-12 in the January column from my summary tab, is there a formula that I can easily copy all over my summary tab?

I’d be wanting the same results from each one (e.g. row X column 1-12 from each month)

#22

You need to construct values for the references, then use the indirect function (or nest the two)

So for the reference, say if you wanted to reference cell A2 on a tab called Sheet1, use:
=“Sheet1!A2”

Then to look up that value use
=INDIRECT(“Sheet1!A2”)

#23

probably want to delete the document and start again, mate.

#24

And what you could do, is instead of having the text in the formula for the sheet name, have a set of cells with the tab names, and have different formulae looking at those cells instead, so use something like:

=INDIRECT(A4&“!A2”)

if you’ve got A4 as “January”

#26

Okay, this almost takes me there, but if I copy that formula down then it doesn’t change from A2, is there a way around that so that it picks up A3, A4, A5, etc? Because I might want to copy it down for hundreds of rows.

#27

I think this is related to your graphics card. There is a setting called ‘ClearType’ that sometimes messes with the rendering of text. You can disable it, but it is probably something that is better left on. You will likely find the spreadsheet looks fine on another computer.

#28

Should have read the thread :stuck_out_tongue:

#29

Sorry - been working (!)

=INDIRECT(“Sheet1!A2”) won’t advance the number as you drag the formula down because the value is in quotes, but if you have a column which has A2, A3, etc in it and you use =INDIRECT(“Sheet1”&B3) where B3 references the column, that should advance as you copy it down

#30

No worries, ended up going =January!$D2 then copying that across and down, then just typing over the month name in each column. If I ever have to do something with more columns though I’ll come back to this, cheers.