Adding Formula to Cells

Excel Help for Adding Formula To Cells in Automating Data Analysis Tasks

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 24 Jan 2007

Replies - Displaying 1 to 1 of 1

Order Replies By: Most Recent | Chronological | Highest Rated

Adding Formula to Cells Rate this: (3/5 from 1 vote) There is a tip here that can save your RSI! 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 10 Apr 2007

Displaying page 1 of 1