Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display zero at the begnning of a number sequence in Excel
How do you format cells so that zero is displayed when it is at the begining
of a number sequence? Example: 031461 displays as 31461. I need the 0 at the begining of the sequence to be displayed as well, but Excel hides it automatically. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display zero at the begnning of a number sequence in Excel
Hi
You could format the cell as text - but this means you can't use it for calculations. An alternative is to use a custom format of 000000 - which will then display 6 digits including leading zeroes if necessary. Andy. "Janelle Lister" wrote in message ... How do you format cells so that zero is displayed when it is at the begining of a number sequence? Example: 031461 displays as 31461. I need the 0 at the begining of the sequence to be displayed as well, but Excel hides it automatically. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display zero at the begnning of a number sequence in Excel
There's a couple of ways 1). Format cell as text 2). Enter a ' before text 3). Format cell as "0"General 4). If a mobile Number leave a gap 07777 777777 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=565627 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
The number in this cell is formatted as text or preceded by an apostrophe" problem in Excel | Excel Discussion (Misc queries) | |||
Calendar Control in Excel 2000 can't display date in Excel 2003? | Excel Discussion (Misc queries) | |||
I don't want to display any controls in excel. | Excel Discussion (Misc queries) | |||
In Excel how can a number automatically display in text form | Excel Worksheet Functions | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) |