| Home |
| Search |
| Today's Posts |
|
|
|
#1
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) | |||
Hybrid Mode
