stop excel from auto editing my numbers
If you want the leading zero to display, you have a decision to make.
If you want the values to be NUMBERS, set the number format to display the
leading zero:
<format<cells<number tab
Category: custom
Type: 00
Click [OK]
Note: The if you type 02, the value will be 2, but will display as 02.
If you want the values to be text, set the number format to Text
<format<cells<number tab
Category: Text
Click [OK]
Note: Anything you type in the cells will be text....even formulas
Does that help?
--------------------------
Regards,
Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
:
"HoganD87" wrote in message
...
I type in 01, 02, 03 etc. but of course excel will turn it into 1, 2, and
3.
solution?
|