How to extract part of one number cell in calc?


I have a large list of codes with nine digits and i wish to save only the last six digits of each code cell.
I’ve tried =RIGHT(A49,6) but i get an “error509” and the formula is changed to =right(A490,6).

Can anyone help me, please?

Thank you

Is your argument separator , (comma), or is it ; (semicolon)?

I suspect the latter; and your decimal separator is likely , .