View Single Post
  #2   Report Post  
Ron Coderre
 
Posts: n/a
Default Steps to deleting decimel in excel-ex. 3.24 to 324

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

Does that help?
(If not....EditUndo!)

€˘€˘€˘€˘€˘€˘€˘€˘€˘€˘
Regards,
Ron


"using excel" wrote:

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