Y yethela Oct 1, 2003 #1 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???
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???
R Ron Rosenfeld Oct 1, 2003 #2 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??? Click to expand... 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
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??? Click to expand... 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 Oct 1, 2003 #3 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
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
R Ron Rosenfeld Oct 1, 2003 #4 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 Click to expand... Much more effective than my attempt. I didn't even try numbers greater than ABS(1) with that format! --ron
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 Click to expand... Much more effective than my attempt. I didn't even try numbers greater than ABS(1) with that format! --ron
