+ Reply to Thread
Results 1 to 4 of 4

change numbers from 1.000.000 to 1.000000

  1. 05-09-2014, 04:14 PM #1
    Jorgelina
    Jorgelina is offline
    Registered User
    Join Date
    05-09-2014
    MS-Off Ver
    Excel 2003
    Posts
    2

    Question change numbers from 1.000.000 to 1.000000

    a need to change a column of numers from this

    -993.532
    -992.666
    -992.687
    -992.955

    to

    -9.9353
    -9.92666
    -9.92687
    -9.92955

    I'm working with Excel 2013

    Please, help!!! I don't know what else to try!
    Reply With QuoteRegister To Reply
  2. 05-09-2014, 04:19 PM #2
    RudiS
    RudiS is offline
    Valued Forum Contributor
    Join Date
    07-04-2012
    Location
    Cape Town, RSA
    MS-Off Ver
    Office 365 ProPlus
    Posts
    1,050

    Re: change numbers from 1.000.000 to 1.000000

    You can multiply it by 0.01

    Welcome to the forum
    Regards,
    Rudi
    Reply With QuoteRegister To Reply
  3. 05-09-2014, 04:20 PM #3
    XOR LX
    XOR LX is offline
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: change numbers from 1.000.000 to 1.000000

    Hi,

    =A1/100

    though your first result is inconsistent.

    Regards
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/
    Reply With QuoteRegister To Reply
  4. 05-09-2014, 04:25 PM #4
    Jorgelina
    Jorgelina is offline
    Registered User
    Join Date
    05-09-2014
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: change numbers from 1.000.000 to 1.000000

    It worked perfectly!! Thanks so much!! :D
    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. [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
  3. 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, 06:05 PM
  4. 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, 02:05 PM
  5. How to change a series of positive numbers to negative numbers
    By Ellie in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-05-2005, 01:05 PM

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