Decimal Formatting

P

Paul Smith

Is there any way to format a column so that the decimal places line up,
without adding decimal places to figures that do not have them, i.e. turn...

219.4
306
180.3
219.2
198

into

219.4
306
180.3
219.2
198
 
D

Dave Peterson

Can you live with:

219.4
306.
180.3
219.2
198.

(Note the decimal points on the whole numbers)

If yes, then give it a custom format of:
#,##0.???
 
Top