LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Monique
 
Posts: n/a
Default consecutive numbers

Hi,

I am looking for a formula that has a consecutive number range starting from
001 and ending at 999. I do not use all of them in one day. My goal is to
be able to revert back to 001 when the last number of my sequence (999) is
reached automatically. This is for an excel spreadsheet that does not
expand beyond 999.

Thank you for your help!

Monique
 
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
Count Consecutive Numbers in a Row Sam via OfficeKB.com Excel Worksheet Functions 5 February 19th 05 02:49 AM
How do I add consecutive numbers but start over at break in the. FLKULCHAR Excel Discussion (Misc queries) 3 December 26th 04 10:17 PM
How do I add consecutive numbers but start over at a break in the. Hockley Excel Discussion (Misc queries) 1 December 24th 04 05:11 PM
How do I add consecutive numbers but start over at a break in the. hockleyc Excel Discussion (Misc queries) 0 December 24th 04 04:15 PM
Generate consecutive numbers alexcooper2003 Excel Worksheet Functions 1 November 22nd 04 02:37 PM


All times are GMT +1. The time now is 07:27 PM.

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

About Us

"It's about Microsoft Excel"