How do you remove some numbers in a series eg 1500024500 = 24500
 

Please help

How do you remove some numbers in a series eg 1500024500 = 24500
 

Hi

If they are always the same length then
=RIGHT(A1,5)
This will return a Text value. If you want it as a numeric value then
=--RIGHT(A1,5)

--
Regards

Roger Govier


"BobDylanfreak" wrote in
message ...
Please help

How do you remove some numbers in a series eg 1500024500 = 24500
 

"BobDylanfreak" wrote:

Please help
Thank you all i have solved the problem

Cheers,
BobDylanfreak