Y
yethela
Can anyone here tell me how I can get rid of the zero that is in front
of the decimal. Example: Make 0.50 look like .50???
of the decimal. Example: Make 0.50 look like .50???
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Ron Rosenfeld
Can anyone here tell me how I can get rid of the zero that is in front
of the decimal. Example: Make 0.50 look like .50???
One method would be to use custom formatting. But since you are limited to
three formats, if your numbers can be positive or negative, then 0 would be
represented by .00
Custom format: [<=-1]-#.00;[<1].00;#.00
will result in:
-1 -1.00
-0.5 -.50
0 .00
0.5 .50
1 1.00
--ron
G
Gord Dibben
Format>Cells>Custom.
Select the 0.00 format and place the cursor in the dialog box. Delete the 0
left of the .00 and OK
Gord Dibben Excel MVP XL2002
Select the 0.00 format and place the cursor in the dialog box. Delete the 0
left of the .00 and OK
Gord Dibben Excel MVP XL2002
R
Ron Rosenfeld
Format>Cells>Custom.
Select the 0.00 format and place the cursor in the dialog box. Delete the 0
left of the .00 and OK
Gord Dibben Excel MVP XL2002
Much more effective than my attempt. I didn't even try numbers greater than
ABS(1) with that format!
--ron