Steps to deleting decimel in excel-ex. 3.24 to 324
If all have 2 decimal places, put 100 in a cell, copy the cell, select
the range in question and Edit|Paste Special|Multiply.
If a helper column is acceptable,
=A1*100
for 2 decimal places, or
=VALUE(SUBSTITUTE(A1,".","")
in general.
Jerry
using excel wrote:
How can I delete the decimel point in a cell but keep the value entered-ex.
3.24 to 324
|