Simple Division Across a table

[montanaaggie]

I received a table in with values in thousands and need to get it to millions. Is there a way I can highlight values from A1 to G10 and force it to divide every cell by 1000. Or do I have to do that manually in each cell.

Dave

 

[mikerickson]

put .001 in a seperate cell. Copy that cell. Select A1:G10 and PasteSpecial with multiply checked.

 

[montanaaggie]

Thanks so much!