=--LEFT(A1,LEN(A1)-1)

Dan E

"supersonicf111" wrote in message ...
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!!!!


---
Message posted from http://www.ExcelForum.com/