Alignment

S

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.
 
F

Frank Kabel

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

Frank
 
Top