i'm unable to follow u...pls explain me clearly

"Bernd P" wrote:

Hello,

Put a double unary minus before your text expression - this will
enforce a transformation into a number:

--A1 will result in 3 if A1 contains a text like "003".

Regards,
Bernd