I AM TRING TO TYPE A 20 CHARACTER NUMBER IN THE CELL PUT EXCELL K.

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

Guest

I AM TRING TO TYPE A 20 CHARACTER NUMBER IN THE CELL PUT EXCELL KEEPS
CHANGING THE LAS NUMBERS TO ZEROS HOW CAN I PREVENT THIS FROM HAPPENING.
 
Please don't post in all CAPS.

Excel is limited to 15 digits of precision, so for longer numbers
like credit card numbers, you need to format the cell as Text
prior to entering the data, or preceding the number with an
apostrophe.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
You must log in or register to reply here.

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

Locking only one cell in Excel 2007 2
convertion formula for (min/mile) to (mile/hr) 3
In creating a COUNTIF and a COUNT to show as ie 4of10? 2
Displaying zeros in cells 2
How to ignore blank date cells in sumproduct 5
Red cell for negative numbers in Excel 1
characters around numbers 3
if a cell value changes, update date in another cell. 2

Back
Top