transforming cells

  • Thread starter Thread starter cmhh
  • Start date Start date
C

cmhh

I may be missing something but....

How would I go about, say, rounding a cell to 2 decimal places. I d
not want to enter =round(a1,1000) in some nearby cell-- I want t
replace a1 with a value that is rounded. Something like a format, but
don't want to be able to recover the original value of the cell...

I have a very good reason for wanting to do this, and the example i
not limites to ronding..
 
Hi, if you want to overwrite the contents of each cell, you could eithe
do it in 2 stages - the 1st as you describe, =round(a1,2) in som
nearby column, then copy the values generated over your original data.

Or, select the range of cells you want to convert, and run this code:

Sub two_decs()
For Each cc In Selection.Cells
cc.Value = Round(cc.Value, 2)
Next
End Su
 
Hi
try
- goto ' Tools- Options - Edit'
- choose your 'fixed decimals'

Note: this will change all your values better to make a backup prior to
doing this)
 
Back
Top