Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 36
Default rolling 4 digit numbers for 4d?


  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 857
Default rolling 4 digit numbers for 4d?

Hi,

1. Please put your questions in the body of the email, when we press Replay
in the Web interface we get

"An error occurred while sending your post
--------------------------------------------------------------------------------

We're sorry, but there was a problem with the system and your post was not
received. The error has been reported to Operations and will be investigated
as soon as possible. Please try again later."

2. what is your question?

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire

"Curious" wrote in message
...

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,856
Default rolling 4 digit numbers for 4d?

I think this is what you want:

=INT(6*RAND()+1)*1000+INT(6*RAND()+1)*100+INT(6*RA ND()+1)*10+INT(6*RAND
()+1)

In future, use the message body to explain what you want, rather than
try to cram it into the header.

Hope this helps.

Pete

On Jan 8, 6:43*am, Curious wrote:


Reply
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
Store numbers starting with zero as 2 digit numbers twisted1825 Excel Discussion (Misc queries) 8 January 11th 07 06:41 PM
How do I sum numbers in rolling format? (4 qtrs=4 cells to left) Deb Excel Discussion (Misc queries) 2 April 19th 06 04:46 PM
what is the minimum numbers set for 4 digit numbers from 0000 to 9 Ambika Excel Discussion (Misc queries) 14 January 27th 06 10:50 PM
Z Chart i.e. top rolling annual bottom rolling monthly middle cum. wat prin Excel Worksheet Functions 0 January 28th 05 03:43 PM
16 DIGIT NUMBERS IN CELL WITHOUT LAST DIGIT BEING A ZERO jnkell Excel Worksheet Functions 2 December 18th 04 07:13 PM


All times are GMT +1. The time now is 01:03 AM.

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"