| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
automaticly add 6 zero when i type a number
In Excel 2003 i had a cell that would automaticly add 6 zeros to the
beginning of a number. If i typed in " 1234 " it would look like this " 0000001234 " I did this by custominzing the fomat of the cell with " 000000#### ". Have upgraded to Excel 2007 and now it doesn't work anymore. Now it displays " 0012 ". i've tried every combo i can think of to make this work but can't get it right. Does anyone know what i should do? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| When I type a constant number I want another number to appear. | Excel Worksheet Functions | |||
| Adding new 'Type' to Format->Number->Time->Type | Excel Discussion (Misc queries) | |||
| How do I type number that begins with a zero to keep zero? | Excel Discussion (Misc queries) | |||
| how do i create an automaticly generating number for a document? | Excel Discussion (Misc queries) | |||
| how do I type in a number and have it automaticly add to the exs. | Excel Worksheet Functions | |||
Threaded Mode
