How can I delete the decimel point in a cell but keep the value entered-ex. 3.24 to 324
U using excel Nov 4, 2005 #1 How can I delete the decimel point in a cell but keep the value entered-ex. 3.24 to 324
R Ron Coderre Nov 4, 2005 #2 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
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
J Jerry W. Lewis Nov 5, 2005 #3 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
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
