| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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!!! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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!!! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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!!! |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formatting numbers as 1st 2nd | Excel Worksheet Functions | |||
| Formatting numbers | Excel Discussion (Misc queries) | |||
| Formatting numbers | Charts and Charting in Excel | |||
| formatting numbers | Excel Programming | |||
| formatting numbers | Excel Worksheet Functions | |||
Linear Mode
