I enter the number to the excel cell - 5391232093670185 but excel puts 5391232093670180. Last digit is zero instead of five. How to fix this?
I enter the number to the excel cell - 5391232093670185 but excel puts 5391232093670180. Last digit is zero instead of five. How to fix this?
It is because excel cell can have only 15 digits number greater than it convert last digit into 0.
You can put greater than 15 digit in to only in text format for doing so add ' then type the numbers.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
What should I choose for formatting? Number or General?
Whatever you want to choose???
Once you convert any number into text or use ' before any number ( for converting number into text) it mean the cell has automatic formatted as text weather cell format is in General or number.
Thank you for your help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks