ExcelBanter - how do i stop excell from turning the last five digits in a 20 di.

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how do i stop excell from turning the last five digits in a 20 di. (https://www.excelbanter.com/excel-discussion-misc-queries/19544-how-do-i-stop-excell-turning-last-five-digits-20-di.html)

cingularws

how do i stop excell from turning the last five digits in a 20 di.

I am looking for an answer to how do i stop excell from turning the last five
digits in a 20 digit number

Peo Sjoblom

Look in help for limitations or specifications, Excel has 15 digits or
precision, if you want to display a
larger number precede with an apostrophe or preformat as text

--
Regards,

Peo Sjoblom

"cingularws" wrote in message
...
I am looking for an answer to how do i stop excell from turning the last
five
digits in a 20 digit number

All times are GMT +1. The time now is 05:35 PM.