ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Number Formatting (https://www.excelbanter.com/excel-programming/387198-number-formatting.html)

Ayo

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!!!!

Jim Jackson

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