| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
When I enter a number, why do I get #### appearing instead of dig
I type in or paste a number, but ########## appears instead of the digits.
The cells are formated to be numbers. Any help would be appreciated. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
When I enter a number, why do I get #### appearing instead of dig
That's only because you have little space to show the entire number. If you
enlarge the respective column width, (or double click in it's header - make an "auto adjustment"), you'll manage to see the whole number. Regards "KAL" escreveu na mensagem ... I type in or paste a number, but ########## appears instead of the digits. The cells are formated to be numbers. Any help would be appreciated. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
When I enter a number, why do I get #### appearing instead of dig
try widening the column
-- Don Guillett SalesAid Software "KAL" wrote in message ... I type in or paste a number, but ########## appears instead of the digits. The cells are formated to be numbers. Any help would be appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| i want cells to auto fill with colour when i enter a number | Excel Discussion (Misc queries) | |||
| How do I enter formula that adds a range if less than a number or | Excel Worksheet Functions | |||
| how can I enter a 21 digit number in a cell & keep it from change | Excel Discussion (Misc queries) | |||
| How do I enter a formula in a cell so that letters= a number i.e.. | Excel Worksheet Functions | |||
| When I enter a number in an empty cel, de cel returns the value d. | Excel Discussion (Misc queries) | |||
Linear Mode
