| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom Format on 16 Digit Number
Excel's precision for numerical entries is 15 decimal digits.
You can either format the cell as Text before entering the number (including the dashes) or precede the entry with an apostrophe (which will not show in the cell) In both cases, it is not a number for Excel anymore, it is text. Probably, that is what you require as well -- Kind regards, Niek Otten Microsoft MVP - Excel "Neil" wrote in message ... When I try to format a 16 digit number into 1111-2222-3333-4444 the last number is displayed as a "0". How do I get the last number to display correctly? -- Neil |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to format cell to display S("6 digit number here) | New Users to Excel | |||
| Format divide by 10 / single digit view: Custom? Text(Round( | Excel Discussion (Misc queries) | |||
| Create number format for 4 digit integer preceded by zero | Excel Worksheet Functions | |||
| How do i format a 5 to 6 digit number into the correct date? | Excel Worksheet Functions | |||
| Cell will not format numbers correctly for a 13 digit custom barc. | Excel Worksheet Functions | |||
Threaded Mode
