Getting Rid of the Zero

[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???

 

[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

 

[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

 

[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