| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format Problem
I have a list of products e.g Product 123 1453 14547 23 234 I want a zero to go at the begiining of each product e.g Product 0123 01453 014547 023 0234 I have done this through the format option then custom 0####### However looking at the display in the top to the right of the fx sign the numbers don't have there zeros is it possible to make them keep there zero's. Chris -- cj21 ------------------------------------------------------------------------ cj21's Profile: http://www.excelforum.com/member.php...o&userid=25673 View this thread: http://www.excelforum.com/showthread...hreadid=527565 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem displaying recordsets in Excel Format | Excel Discussion (Misc queries) | |||
| Format cell problem | Excel Discussion (Misc queries) | |||
| Date conditioning format problem | Excel Discussion (Misc queries) | |||
| date format problem | Excel Discussion (Misc queries) | |||
| Problem with txt format | Excel Discussion (Misc queries) | |||
Threaded Mode
