I need to be able to take a currency number such as $1,350,000.00 and turn it into 1.350. I have a huge spreadsheet that are calculations that I need this way for a reason but then when showing this same information on another chart, I need to convert it to the smaller number format. help!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Creating Macro for Number conversion
- Thread starter ragan
- Start date
ragan,
If you actually want to divide them all by 1000000.000
Type the number 1000000.000 in any empty cell (cell D1), and format that cell as a Number with 3 decimal places.
Copy that cell (cell D1).
Select your range of data (range A1:B10) then click Edit -> PasteSpecial -> Divide
And click on the OK button.
If you actually want to divide them all by 1000000.000
Type the number 1000000.000 in any empty cell (cell D1), and format that cell as a Number with 3 decimal places.
Copy that cell (cell D1).
Select your range of data (range A1:B10) then click Edit -> PasteSpecial -> Divide
And click on the OK button.
Upvote
0
Similar threads
- Solved
