Hi, then you can try the conditional formatting.
For example, you can choose to only apply the scale to the rows without "percentage" in the row names using the below:
If (RowName DoesNotContain 'percentage') Then
Scale = 6, NumberFormat = N1
End If
It is the excel syntax for number formats.
Is there a reason, not to use the scale option?
Hello,
No there is no reason not to use the scale option. Do you think that it is better suited?
Yes, if you set it to 6 and then use number format N1 or N2, then you should get what you are looking for.
If you want to use format, you can try #,, #.0,, or #.00,,
If you google excel custom format, you will get plenty of results explaining the concepts behind it.
Hello, I tried NumberFormat = N1, Scale = 6 and it works in terms of displaying the numbers in millions, however it messed up some percentage calculations that I was making beforehand. I think this is because of the scaling. Is there a way to get around it?
Hi, then you can try the conditional formatting.
For example, you can choose to only apply the scale to the rows without "percentage" in the row names using the below:
If (RowName DoesNotContain 'percentage') Then
Scale = 6, NumberFormat = N1
End If
