Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I keep the 0 at the beginning of my order? (098523)
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" |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I keep the 0 at the beginning of my order? (098523)
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I keep the 0 at the beginning of my order? (098523)
Three ways 1) Format the cell as text 2) Enter ' before the number 3) Enter the text with a space lile a mobile number 07753 666 111 All three ways converts the number to text VBA noob -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833 View this thread: http://www.excelforum.com/showthread...hreadid=564501 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |