Forum Discussion

ccirsteahon's avatar
ccirsteahon
Copper Contributor
Jan 04, 2023
Solved

I can not input some values

Hi,   I have trouble entering some values in Excel.   I try to add 7080051902836478 in any cell and automatically change the number with 0 at the end instead of 8.   Can you please help me to f...
excel
  • NikolinoDE's avatar
    NikolinoDE
    Jan 04, 2023

    ccirsteahon 

    Excel can only display 15 digits. The limitation of 15 digits is defined in the Excel specification, unfortunately you cannot change it.

     

    Workarounds:

    You can write the number with an apostrophe '7080051902836478 then it will appear as desired.

    You can also convert the number to text from the Format Cells menu

    ... (right-click the cell you want and choose "Format Cells", you'll find the rest :).

     

     

    Hope I was able to help you with this info.

     

    NikolinoDE

    I know I don't know anything (Socrates)

    Was the answer useful? Mark them as helpful!

    This will help all forum participants.

NikolinoDE's avatar
NikolinoDE
Platinum Contributor
Jan 04, 2023

ccirsteahon 

Excel can only display 15 digits. The limitation of 15 digits is defined in the Excel specification, unfortunately you cannot change it.

 

Workarounds:

You can write the number with an apostrophe '7080051902836478 then it will appear as desired.

You can also convert the number to text from the Format Cells menu

... (right-click the cell you want and choose "Format Cells", you'll find the rest :).

 

 

Hope I was able to help you with this info.

 

NikolinoDE

I know I don't know anything (Socrates)

Was the answer useful? Mark them as helpful!

This will help all forum participants.

Resources