Number Formatting
I am having a problem with formatting a number with a leading zero. I know I
have to use custom format and enter 00000 for the number, i.e., 08667. My problem is after I have done that and everything looks OK, when I go back to the cell format dialog window, the Category is changed to Special and the Locale is changed to Chinese. Hlep!!!! |
Number Formatting
Format as text, then re-input the number.
-- Best wishes, Jim "Ayo" wrote: I am having a problem with formatting a number with a leading zero. I know I have to use custom format and enter 00000 for the number, i.e., 08667. My problem is after I have done that and everything looks OK, when I go back to the cell format dialog window, the Category is changed to Special and the Locale is changed to Chinese. Hlep!!!! |
All times are GMT +1. The time now is 12:54 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com