LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 1
Default 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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Making Lists of numbers nebula Excel Discussion (Misc queries) 5 May 10th 08 01:57 AM
Making a chart from Row of numbers David Excel Discussion (Misc queries) 2 January 9th 07 01:31 AM
Making a chart of numbers that are grouped together David Excel Discussion (Misc queries) 1 January 3rd 07 01:54 PM
Help making Negative numbers to become zero jrabs12 Excel Worksheet Functions 14 August 8th 06 09:00 AM
making a list of numbers. toddb123 Excel Discussion (Misc queries) 3 April 21st 05 12:21 PM


All times are GMT +1. The time now is 12:35 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"