| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
0987 show in the cell - the zero drops off-ned all 4 digits
I type in 0987 in the top bar and yet I press enter the number in the row
cell shows 987 and the top bar no longer has the zero. I looked at format and i have tried number , general, custom etc -- HOw to get the zero and all four digits to show? Thanks Mike |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Truncating numbers to show last three digits | Excel Discussion (Misc queries) | |||
| My Cell drops the Zero if it is first. | Excel Discussion (Misc queries) | |||
| formula locates common data in a cell and drops them in other shee | Excel Discussion (Misc queries) | |||
| Combo Box - Show only first two digits? | Excel Discussion (Misc queries) | |||
| How do I shorten 10-digit # so only 6 digits show up? | Excel Discussion (Misc queries) | |||
Threaded Mode
