| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
19 Digits in a Cell
It has been necessary to put 19 digits in a cell but the last four revert to Zeros (0000) I have attempted various formats of the cell but of no availe, Why? and Help please.  Bri-- bri ------------------------------------------------------------------------ bri's Profile: http://www.excelforum.com/member.php...o&userid=27704 View this thread: http://www.excelforum.com/showthread...hreadid=489539 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
19 Digits in a Cell
Preformat the cell as text (format|cells|number tab|Text)
Or start your entry with an apostrophe: '1234123412341234123 bri wrote: It has been necessary to put 19 digits in a cell but the last four revert to Zeros (0000) I have attempted various formats of the cell but of no availe, Why? and Help please. Bri-- bri ------------------------------------------------------------------------ bri's Profile: http://www.excelforum.com/member.php...o&userid=27704 View this thread: http://www.excelforum.com/showthread...hreadid=489539 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to insert a value in one cell into many cells | Excel Worksheet Functions | |||
| copying cell names | Excel Discussion (Misc queries) | |||
| Cell color based upon cell value | Excel Discussion (Misc queries) | |||
| cell color index comparison | New Users to Excel | |||
| VLookup resulting in a blank cell... | Excel Worksheet Functions | |||
Linear Mode
