Formatting Numbers
 

Hi,
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. Does anyone knows what is going on? Help
Please!!!

Formatting Numbers
 

After formatting as text, you can input the number and the 0 will rmain.
--
Best wishes,

Jim


"Ayo" wrote:

Yes. It takes out the leading zero. I need the leading zero.

"Jim Jackson" wrote:

Will formatting as "Text" create problems?
--
Best wishes,

Jim


"Ayo" wrote:

Hi,
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. Does anyone knows what is going on? Help
Please!!!

Formatting Numbers
 

That works if I was just entering a number, but I have a dropdown list and it
does work for that. It still removes the leading zero.

"Jim Jackson" wrote:

After formatting as text, you can input the number and the 0 will rmain.
--
Best wishes,

Jim


"Ayo" wrote:

Yes. It takes out the leading zero. I need the leading zero.

"Jim Jackson" wrote:

Will formatting as "Text" create problems?
--
Best wishes,

Jim


"Ayo" wrote:

Hi,
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. Does anyone knows what is going on? Help
Please!!!

Formatting Numbers
 

On Apr 11, 1:26 pm, Ayo wrote:
That works if I was just entering a number, but I have a dropdown list and it
does work for that. It still removes the leading zero.



"Jim Jackson" wrote:
After formatting as text, you can input the number and the 0 will rmain.
--
Best wishes,

Jim

"Ayo" wrote:

Yes. It takes out the leading zero. I need the leading zero.

"Jim Jackson" wrote:

Will formatting as "Text" create problems?
--
Best wishes,

Jim

"Ayo" wrote:

Hi,
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. Does anyone knows what is going on? Help
Please!!!- Hide quoted text -

- Show quoted text -


How about if you use the zip-code format? Then you could keep the
leading 0's and it'll stay as english.