0

I have already went through all previous questions but didn't find an answer to my question. I need to display this number 4935320154684405 but there's no way Excel let me do it. It displays 4,93532E+15 or 4935320154684400 but never the correct one.

How can I get Excel to display the number in full?

Improve this question
3
  • Welcome to Super User. Have you tried to change the cell format to text so it will allow the entire number to be displayed?
    – CharlieRB
    Mar 12, 2015 at 14:15
  • Thank you CharlieRB, changing cell format to text let it display the number as I want but is useless if i need to use it for calculation
    – mussinata
    Mar 12, 2015 at 16:23
  • Sorry. You asked how to display it, but said nothing about using it in a calculation. That is an important detail.
    – CharlieRB
    Mar 12, 2015 at 17:00

1 Answer 1

Reset to default
0

You need to set a custom cell format.
Select the cell format dropdown and change it to select the number of digits required.

You can remove the comma separators as you wish

Screengrab of format dialogue

Improve this answer
1
  • Thanks Chemunka, I already tried with custom in cell format but it doesn't work
    – mussinata
    Mar 12, 2015 at 16:14

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .