Alignment

[Steven Ridley]

Hello All,

I am creating a worksheet that has decimal values. I
would like to know if there is a way to align the values
in the column so that the decimal place (.) are all
aligned no matter how many vaules are on each side of the
decimal place - for example:

239.0
30.25
111.2

Thanks in anticipation of assistance with this matter.

Steven.

 

[Frank Kabel]

Hi Steven
try the following custom format
0.????
use as many '?' as you have digits left from the decimal place

Frank

 

[Guest]

Thanks Frank - your solution works a dream

Steven.

 

[Frank Kabel]

Hi Steven
thanks for the feedback
Frank