Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
work sheet
When entering a 16 digit account number, the cell is replacing my last number
with a zero. Can anyone help with this? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
work sheet
Format the cell as Text, or prefix the number with an apostrophe (').
XL's specifications allow 15 digits of decimal precision, which is why the 16th digit is truncated. Most of the time, people enter 16 digit number for credit cards, which don't need math done on them. If you do need to do math with 16 digit numbers, you'd be better off with a different application. In article , Busch Satellite <Busch Satellite @discussions.microsoft.com wrote: When entering a 16 digit account number, the cell is replacing my last number with a zero. Can anyone help with this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
extracting totals from 1 work sheet to another work work sheet | Excel Discussion (Misc queries) | |||
GETTING SELECTED DATA FROM A WORK SHEET TO OTHER WORK SHEET | Excel Discussion (Misc queries) | |||
Populating work sheet combox with another work sheet values | Excel Discussion (Misc queries) | |||
Is there away to keep "auto save" from jumping to the first work sheet in the work book? | New Users to Excel | |||
Spin button in a work sheet - how do I make it work? | Excel Worksheet Functions |