Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Steps to deleting decimel in excel-ex. 3.24 to 324
How can I delete the decimel point in a cell but keep the value entered-ex.
3.24 to 324 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting Rows in MS Excel | Excel Discussion (Misc queries) | |||
excel 4.0 macro removal tool | Excel Discussion (Misc queries) | |||
excel 4.0 macro remover tool | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
VBA for Excel 2000 file is corrupt | Excel Discussion (Misc queries) |