want only last four digits of number

[Guest]

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

 

[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