| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to display a number beginning with zero
I want to display a four digit number which may or may not begin with zero,
i.e. (0215) (0050) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to display a number beginning with zero
You can format the cell beforehand as Text, or you could type an apostrophe
immediately before the number, e.g. '0400 will display as 0400. Hope this helps. Pete "DeeKay" wrote in message ... I want to display a four digit number which may or may not begin with zero, i.e. (0215) (0050) |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to display a number beginning with zero
Try
use a custom cell format of 0000 that's 4 zeroes Mike "DeeKay" wrote: I want to display a four digit number which may or may not begin with zero, i.e. (0215) (0050) |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to display a number beginning with zero
Thank you both (Pete & Mike) so much
"DeeKay" wrote: I want to display a four digit number which may or may not begin with zero, i.e. (0215) (0050) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I display zeros in excel if they are the beginning characte | Excel Discussion (Misc queries) | |||
| How can I display numbers beginning with zero? | Excel Discussion (Misc queries) | |||
| Zero at the beginning of a number | Excel Discussion (Misc queries) | |||
| How to display the number zero at the beginning of a number when . | New Users to Excel | |||
| How do I display an insignificant 0 at the beginning of a number | Excel Discussion (Misc queries) | |||
Hybrid Mode
