Custom Number Formats

C

Christina

Gotta list:

0.25
0.75
1.00
0.50

Want these to appear as follows when typed into a cell (no matter which one
is typed in), preferrable right-aligned:

..25
1.0
..75
..5


Is there a custom format that can be used for this? Thanks. _c
 
B

Bob Phillips

#.0#

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Top