Converting data

  • Thread starter Thread starter Sam
  • Start date Start date
S

Sam

How do you convert existing data? For example to
increase all prices, convert dollars to pesos, etc. I'm
assuming it's a simple formula, but I can't seem to find
any info on this.
 
I'm sorry, could you explain that a little bit more? I'm
not an expert on Excel and just want to take a column of
numbers and convert them (multiple) all by the same rate
or value. For example, a 15% increase on all the numbers
in a column without re-wrting everything. Thanks.
 
Put 1.15 in an empty cell, copy it, select the numbers and do edit>paste
special,
select multiply. Or use a help column

=A1*1.15

copy down

(where A1 is the first number)

I would personally use a help column and a formula since I could back track
if needed
and the original values would still be there..
 
Back
Top