LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 47
Default Create 5 of 6 digits randomly.

I would like to create a random conformation number, but only make the last 5
of 6 digits random. I would like to make the first number be the hour witch
the meeting time will start. For ex. (743856) 7 for 7:00 and the other 5
would be random. Any help would be greatly appreciated.
 
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
Hard to do? randomly farmer Excel Worksheet Functions 3 March 27th 08 12:06 PM
How to customize number to 10 digits including 2 digits after deci Carina Excel Worksheet Functions 3 September 20th 07 02:50 AM
how do I create a Date field format for mm/dd/yyyy (10 digits) The Big Kahuna Excel Worksheet Functions 1 October 26th 06 05:32 PM
randomly selection Shea Excel Discussion (Misc queries) 1 April 4th 06 04:49 AM
how do i create a spread sheet with randomly placed numbers 1-500. sarasota Excel Discussion (Misc queries) 1 January 25th 06 04:52 PM


All times are GMT +1. The time now is 09:59 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"