truncating a number

K

KARRY

How do I truncate a number in Excel
eg. I have 12345 in a column, but I want only 123 to be displayed in the adjacent column

Thx
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Display entire number in cell 3
Need Help with a VBA subroutine 0
Truncating Number Series 3
deleting the first 2 digits of number in a cell 2
Open CSV as txt data 5
How to replace text with numbers? (formula) 4
Autonumber field in Excel that behaves the same as Access 0
Excel does not accept text format! 0

Top