View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Steve Garman Steve Garman is offline
external usenet poster
 
Posts: 107
Default Removing the rightmost digit

supersonicf111 wrote:
I'm full of questions today, is there a way to remove the rightmost
digit from a list of numbers? Example below.


Original number

123456


Returned number

12345

Thanks in advance for your help!!!!


Dim x As Long, y As Long
x = "123456"
y = Int(x / 10)
MsgBox y


--
Steve Garman