formatting

  • Thread starter Thread starter DAN
  • Start date Start date
D

DAN

i have the following amounts in a column
6.00
7.00
8.00
80.00
100.00

i want to get rid of the . but keep the 0's is there a
way to do this?
 
Hi Dan

one way - which will change the values into 600 / 700 / 800 / 8000 etc
type 100 into a blank unused cell
copy it
select your numbers
choose edit / paste special - click the multiply box
click OK

Cheers
JulieD
 
Back
Top