| Home > Forum Home > Automating Data Analysis Tasks > Adding Formula to Cells | Share |
Adding Formula to Cells
Excel Help for Adding Formula To Cells in Automating Data Analysis Tasks
| Forum Topic | Post Reply Login |
Adding Formula To Cells | Rate this: (3/5 from 1 vote) |
 | I have a spreadsheet with dollar values in each. I need a quick way to convert them all to short form. For example: $1,000,000 showing as $1 $250,000 showing as .25 I have a lot of numbers to change and one by one entering = #/1000000 is hurting my wrist. Thx!!! | |
| Posted by yolewis on | ||
| Replies - Displaying 1 to 1 of 1 | Order Replies By: Most recent | Chronological | Highest Rated |
| Rate this: (3/5 from 1 vote) Type 1000000 into an empty cell and ctrl+c to copy. Now select the range of cells you want to shorten and from the edit menu choose paste special. Click the Divide option, then Ok. Voila! Another option, that wont change the actual value of the cell, is to consider formatting the cell as Scientific format. ~Shiv |
| Posted by shiv_379 on |
| Displaying page 1 of 1 |
| Find relevant Excel templates and add-ins for Adding Formula to Cells in the Excel Business Solutions Directory |