want only last four digits of number

B

Betsy

I wish to format a column of numbers so that only the last four digits of
each number are there. This is not stripping the leading zeros; it's
stripping whatever numbers are before the last four. How do I do this?

Thanks
 
N

Niek Otten

=MOD(A1,10000)
Format Custom as 0000

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I wish to format a column of numbers so that only the last four digits of
| each number are there. This is not stripping the leading zeros; it's
| stripping whatever numbers are before the last four. How do I do this?
|
| Thanks
 
Top