Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Either preformat the cell as Text (Format|cells|Number tab)
or start your entry with an apostrophe: '098523 Or even give that cell a custom format of: 000000 The first two will treat the value as text. The last one keeps the value as a number. gwlen wrote: I am doing a order form and when I enter the oder number if it starts with "0" after I have entered it and go to the next order it delets the "0" -- Dave Peterson |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
OWC.CHART - Why does my X-Axis come out in the wrong order - somet | Charts and Charting in Excel | |||
Generate Auto Order Number | Excel Discussion (Misc queries) | |||
Series order conflicts with line order | Charts and Charting in Excel | |||
Print order of worksheets | Excel Discussion (Misc queries) | |||
Maintaining a default worksheet order | Excel Discussion (Misc queries) |