Then you didn't use the TEXT() functions the way I illustrated.

Are you trying to add the strings (i.e., using "+") rather than
concatenate ("&")???

That wouldn't explain your example, 06263212103641, if anything, should
be changed to 6.26321E+12, not 1.62632E+13


In article .com,
"Lou" wrote:

When changing the number to text it doesn't retain the correct
number.... changes 06263212103641 to 1.62632E+13