Number format

[apthansh]

I have the below formatted cell..I want to extract numbers after the first 8 digits.I tried the below expression but it is eliminating 0's at the end and also there are some that are getting eliminated in the middle.

mid(Num(Replace(key, ',', '.'), '(dec)'),9) - Output is 1800010

Is there any other work around for this please ?

Thank you much.

[Kushal_Chawda]

try converting it first to text and then extract the string

mid(text(Replace(key, ',', '.')),9) 

or

mid(text(Num(Replace(key, ',', '.'), '(dec)')),9)

[apthansh]

Thank you Khush - I tried this, but no luck..output is same as above.

[apthansh]

I have attached the sample file, if that helps.Thank you much.