Hi,
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 , .