| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel, how enter 15 digits in a cell without rounding off last?
How can I enter over 15 digits in a cell without it rounding off the excess
digits? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
excel, how enter 15 digits in a cell without rounding off last?
You can't enter a numeric value 15 digits so you need to format the cell as
TEXT but obviously you cannot use this for calculations. Not for Credit Card Number by any chance? HTH "mike marcus" wrote: How can I enter over 15 digits in a cell without it rounding off the excess digits? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
excel, how enter 15 digits in a cell without rounding off last?
How can I enter over 15 digits in a cell without it rounding off the
excess digits? You can't enter a numeric value 15 digits so you need to format the cell as TEXT but obviously you cannot use this for calculations. Start with an apostrophe ('). As noted above, this makes a text value, not numeric. You can’t do arithmetic with it the way you may expect. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
excel, how enter 15 digits in a cell without rounding off las
No, transaction #'s and I don't need math calcs. So text is fine. I got it
now thanks "Toppers" wrote: You can't enter a numeric value 15 digits so you need to format the cell as TEXT but obviously you cannot use this for calculations. Not for Credit Card Number by any chance? HTH "mike marcus" wrote: How can I enter over 15 digits in a cell without it rounding off the excess digits? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can excel automatically enter the date data in a cell was entered | Excel Worksheet Functions | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| enter a new value into a cell using macro in excel | Excel Discussion (Misc queries) | |||
| Enter an Excel cell reference as part of a custom header/footer | Excel Worksheet Functions | |||
| How do i enter a note in excel to an unlocked cell on a protected. | Excel Discussion (Misc queries) | |||
Hybrid Mode
