use simple formula in b2
=abs(a2)
even if that number is stored as text you will get number in b2


"Eric" wrote:

In cell A2, there is char 2328050010001023841.
I am not sure whether the char is text or number, does anyone have any
suggestions on how to force it into number?
I have tried following code, but it misses the last 4 digits.
In cell B2, Int(A1) = 2328050010001020000.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric