| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display a 16 digit number
How do you enter a 16 digit number without adding extra numbers on the end or
displaying a formula? I have tried all the Format Cells options with no luck. Many Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Display a 16 digit number
Excel can cope with 15 digits.
Assuming your 'number' is something like a bank account number and no math will be done on the number: type an apostrophe before entering the number; e.g. '1234567887654321 -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "GrlsWthCrls" wrote in message ... How do you enter a 16 digit number without adding extra numbers on the end or displaying a formula? I have tried all the Format Cells options with no luck. Many Thanks! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Display a 16 digit number
Format your cell as text or put an anpostrophe in front of your numbers. i.e '12345678912345678 Regards JG -- pinmaster ------------------------------------------------------------------------ pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261 View this thread: http://www.excelforum.com/showthread...hreadid=498808 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to display current page number in any cell of that page. | Excel Discussion (Misc queries) | |||
| how can I enter a 21 digit number in a cell & keep it from change | Excel Discussion (Misc queries) | |||
| Display a greater number of recently used spreadsheets on File ta. | Excel Discussion (Misc queries) | |||
| In Excel how can a number automatically display in text form | Excel Worksheet Functions | |||
| Display ONLY fraction portion of number | Excel Discussion (Misc queries) | |||
Linear Mode
