Is there a way to display a number more than 12 characters whose format is TEXT-CodePudding

I know how to display a number more than 12 characters whose format is Number.

However, I downloaded an excel and when I open the sheet, I saw like "47821E 12" and I changed the format to TEXT but It won't change.

It still shows "47821E 12".

However, When I double click the cell and enter, It shows right like "47821573839123"

Is there an automated way to solve this problem?

Thanks

CodePudding user response：

If your character count is smaller than 16, you can simply convert the cell type into 'number' which gives you the exact format instead of scientific one.

Update

If the cells has non-numeric charracters, you can try to convert the contents of cells via

=TEXT(A1, "0")

in a new cell, where A1 is the cell has scientific display.