ExcelBanter - How can I show the exact cipher that has 19 numbers in excel?

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

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

- - How can I show the exact cipher that has 19 numbers in excel? (https://www.excelbanter.com/excel-discussion-misc-queries/88256-how-can-i-show-exact-cipher-has-19-numbers-excel.html)

Alf

How can I show the exact cipher that has 19 numbers in excel?

I am trying to to set a cipher of 19 numbers in a cell and it round of the
four last numbers. How can I solve it that it shows it all?

David Biddulph

How can I show the exact cipher that has 19 numbers in excel?

"Alf" wrote in message
...
I am trying to to set a cipher of 19 numbers in a cell and it round of the
four last numbers. How can I solve it that it shows it all?

Format the cell as text. With numbers, Excel only works to 15 significant
figures.
--
David Biddulph

All times are GMT +1. The time now is 08:34 AM.