in reply to how to format cell as text?

In this particular case just print is ok:

D:\>perl -le "$_=23232363283842;print" 23232363283842

But this doesn't:

D:\>perl -le "$_=23232363283842232;print" 2.32323632838422e+016

and in such case I would try to split to groups of digits:

$_=23232363283842232; while($_) { unshift @a, sprintf"%06d", $_%1e6; $_=int($_/1e6); } $a[0]%=1e6; print@a Result: D:\>perl -le "$_=23232363283842232;while($_) { unshift@a,sprintf\"%06d +\",$_%1e6; $_=int($_/1e6); } $a[0]%=1e6;print@a" 23232363283842232

Update: It will work correctly for 0, but for negative integers one must change the input int to opposite and store the minus sign in variable to print it later.

$sign=""; if($_<0) { $_=-$_; $sign="-"; } ...and at the end print $sign,@a