Steps to deleting decimel in excel-ex. 3.24 to 324

[Guest]

How can I delete the decimel point in a cell but keep the value entered-ex.
3.24 to 324

 

[Guest]

Have you tried . . .
•Select the range you want to edit
•Edit>Replace
-Find What: . <-Decimal Point
•Replace With: (leave this blank)
•Click the [Replace All] button

Does that help?
(If not....Edit>Undo!)

••••••••••
Regards,
Ron

 

[Jerry W. Lewis]

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