| Home > Forum Home > Automating Data Analysis Tasks > Adding Formula to Cells > Adding Formula to Cells | Share |
Adding Formula to Cells
Excel Help for Adding Formula To Cells in Automating Data Analysis Tasks
| Forum Topic | Login |
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 | ||
| View Full Post |
| Find relevant Excel templates and add-ins for Adding Formula to Cells in the Excel Business Solutions Directory |