| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Help Needed - Making Numbers
Hi
I want to make a group of numbers but am having trouble. What I am trying to do is make a list like this: 092660000 092660001 092660002 092660003 I get the bit about A1 + 1 and then copy and paste but every time I do it Excel takes out the first 0 so I end up with a list that looks like this: 92660000 92660001 92660002 92660003 thats not what I want, I must have the 0 in front. Any ideas? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help Needed - Making Numbers
Hi,
Am Sat, 21 Jul 2012 10:29:48 +0000 schrieb Bassai: I want to make a group of numbers but am having trouble. What I am trying to do is make a list like this: 092660000 092660001 092660002 092660003 use custom numberformat "000000000" (without the quotes) Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
|
#3
|
|||
|
|||
|
Quote:
Have a look at the attachment. The cells are custom formatted to 000000000 which forces Excel to show that leading zero. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Making Lists of numbers | Excel Discussion (Misc queries) | |||
| Making a chart from Row of numbers | Excel Discussion (Misc queries) | |||
| Making a chart of numbers that are grouped together | Excel Discussion (Misc queries) | |||
| Help making Negative numbers to become zero | Excel Worksheet Functions | |||
| making a list of numbers. | Excel Discussion (Misc queries) | |||
Linear Mode
