| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
display zero values at the beginning of a number.
I would like zero values at the start of a number eg.
0015624 that drops into a cell using a formula. I know that if I type '0015624 then the first two zeros will be displayed. if i type 0015624 into a cell it will read 15624. i would like to display zeros without having to type ' at the beginning so that the formula reads true. is this possible can some one help please Thanks basil |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to display a number beginning with zero | Excel Discussion (Misc queries) | |||
| 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) | |||
| 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) | |||
Threaded Mode
