+ Reply to Thread
Results 1 to 4 of 4

numbers change when i repoen the file

  1. 03-26-2015, 05:23 AM #1
    bakhtawar
    bakhtawar is offline
    Registered User
    Join Date
    03-23-2015
    Location
    n/a
    MS-Off Ver
    2007
    Posts
    34

    numbers change when i repoen the file

    hi

    I paste the values in c2 and enter formula in d2 cell i.e. randbetween(923412123181,923908070675)
    then all the numbers are in correct order in c2 and d2 column but when I save the file in csv(ms-dos format) and after that when I reopen the file numbers look like this both in c2 and d2
    923216000000
    923216000000
    923218000000......

    in whole c2 column
    what should I do ?
    file is attach
    answered.csv
    Last edited by bakhtawar; 03-26-2015 at 05:28 AM.
    Reply With QuoteRegister To Reply
  2. 03-26-2015, 05:27 AM #2
    Special-K
    Special-K is offline
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,064

    Re: numbers change when i repoen the file

    The numbers change because you are using the random function
    Enter the RANDBETWEEN functiion in a cell.
    Now enter any number in a blank cell and the RANDBETWEEN function creates a new number.
    If you use VBA to generate the numbers you can set it so they do not change.
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
    Reply With QuoteRegister To Reply
  3. 03-26-2015, 05:43 AM #3
    bakhtawar
    bakhtawar is offline
    Registered User
    Join Date
    03-23-2015
    Location
    n/a
    MS-Off Ver
    2007
    Posts
    34

    Re: numbers change when i repoen the file

    yes when I enter randbtween formula numbers look like this and this is correct and what I want
    answered2.csv

    but when I save the file and reopen the file numbers look like this
    CalledNumber
    924000000000
    924000000000
    923000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    923000000000
    923000000000
    923000000000
    924000000000
    924000000000
    924000000000
    923000000000
    923000000000
    924000000000
    923000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    923000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    923000000000
    923000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    923000000000
    923000000000
    923000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    923000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    923000000000
    924000000000
    924000000000
    923000000000
    923000000000
    924000000000
    924000000000
    923000000000
    923000000000
    924000000000
    923000000000
    923000000000
    924000000000
    923000000000
    924000000000
    924000000000
    923000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    923000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    923000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    923000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    923000000000
    923000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    923000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    923000000000
    923000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    923000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    923000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    923000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    923000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    923000000000
    924000000000
    924000000000
    923000000000
    923000000000
    923000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    924000000000
    923000000000......
    Reply With QuoteRegister To Reply
  4. 03-26-2015, 05:59 AM #4
    bakhtawar
    bakhtawar is offline
    Registered User
    Join Date
    03-23-2015
    Location
    n/a
    MS-Off Ver
    2007
    Posts
    34

    Re: numbers change when i repoen the file

    anyone help me?
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Detect numbers in a cell range and then change cells based on what numbers are found
    By scum in forum Excel General
    Replies: 7
    Last Post: 02-27-2014, 10:56 PM
  2. Generating Random Numbers that Don't Change When the File is Reopened
    By newbie0101 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-09-2012, 07:25 PM
  3. [SOLVED] change 2000 cells (negative numbers) into positive numbers
    By lisbern in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-16-2006, 01:00 PM
  4. [SOLVED] How to change a series of positive numbers to negative numbers
    By Ellie in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  5. [SOLVED] How to change a series of positive numbers to negative numbers
    By Richard Buttrey in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 09-06-2005, 08:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1