How to convert 10.23 to 1023 by suppressing DECIMAL POINT using VBA.

xlhelp15

Board Regular
Joined
Sep 12, 2014
Messages
113
Office Version
  1. 365
Platform
  1. Windows
  2. Mobile
  3. Web
Hello Experts,


Could you please help me for the below request ?


I need to convert all the decimal values into numbers like below,


if user type 10.23 it needs to change 1023. I have tried it using Format -> Numbers, unfortunately unable to achieve the desired result.

Thanks.
 

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.
What do you want to happen if the user enters an integer like 10? Do you want to change it to 1000? And what about 10.12345?
 
Upvote 0
Yes, absolutely. if user enters an integer like 10 it needs to change as 1000. There are only 2 digits after the decimal point. so user will not key 10.12345, Joe. Thanks much you quick response.
 
Last edited:
Upvote 0
This assumes Column A, change as necessary:

Code:
Private Sub Worksheet_Change(ByVal Target As Range)
Dim c As Range, d As Range
Set d = Intersect(Range("A:A"), Target)
If d Is Nothing Then Exit Sub
Application.EnableEvents = False
For Each c In d
    If IsNumeric(c) And c <> "" Then c = c * 100
Next
Application.EnableEvents = True
End Sub
 
Upvote 0
Solution

Forum statistics

Threads
1,213,514
Messages
6,114,078
Members
448,547
Latest member
arndtea

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top