Cell formating

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi greetings

i am trying to enter a value 80010010078905205 in a cell & i have selected
the format (ctrl1) as Custome>0. After entering the above value in the cell
the system return this value 80010010078905200. the last digit 5 is getting
replaced by 0. I have tried to copy format from another cell which has
similar length of digits, using the format painter. Appreciate your help on
this.

Warm regards

Abhijit Dasgupta
 
Excel cannot handle such a long number. Try and enter it as text by
preceding your entry with a '. The ' will not show, but will ensure that the
entry is reflected correctly. Of course you then cannot calculate on this
number. If it is a credit card number, I would use either the ', or put
spaces between the groups of digits.
'80010010078905205 or 8001 0010 0789 0520 0
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA 1
Problem with Values greater than a quardrillion(1,000,000,000,000, 1
Excel Macro to automatically go to the right of the last colored cell 0
Custom formatting in Excel 2007 1
unable to enter date into cell which should be formatted for dates 1
Need cell format to display 025349 as 02-5349 & display 1st zero 3
For Joey2004 et al. From OP: Re Appending Question 3
Adding recognised Zeros 5

Back
Top