| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format Cell as custom type but data doesn't display like I custom.
I format the cell as custom type like 0000 0000 0000 0000 in order that the
number the user key in the cell 1111222233334444 (without space) will display like 1111 2222 3333 4444 automatically. But the problem is when I key in 1111222233334444 the last number always becomes ZERO at all time like 1111 2222 3333 4440. How can I fix that? Could you please help me? Many thanks. ToMMie |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom number display format | Excel Worksheet Functions | |||
| Excel Format Cells - Number Tab - Custom - Order of Type Window. | Excel Discussion (Misc queries) | |||
| How do I display custom file properties in a cell | Excel Discussion (Misc queries) | |||
| Format cells, custom type, delete | Excel Discussion (Misc queries) | |||
| Why does Custom Format not control Cell Display? | Excel Discussion (Misc queries) | |||
Threaded Mode
