| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dates in cells are no longer visable but are showing as ########
My column of cells are formatted as date (03/04/08). First 16 lines in
column are showing correctly but now all I see when I imput the correct date (different each time) is #######. Sheet is not locked. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dates in cells are no longer visable but are showing as ########
Widen the column
"joh" wrote: My column of cells are formatted as date (03/04/08). First 16 lines in column are showing correctly but now all I see when I imput the correct date (different each time) is #######. Sheet is not locked. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dates in cells are no longer visable but are showing as ########
Or use a smaller font.
Or make sure that the text isn't showing a 4 digit year. joh wrote: My column of cells are formatted as date (03/04/08). First 16 lines in column are showing correctly but now all I see when I imput the correct date (different each time) is #######. Sheet is not locked. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy visable cells only | Excel Worksheet Functions | |||
| cells visable and following. Not freeze | Excel Worksheet Functions | |||
| pasting into visable cells only | Excel Discussion (Misc queries) | |||
| Summing visable cells only | Excel Discussion (Misc queries) | |||
| Visable Cells | Excel Discussion (Misc queries) | |||
Linear Mode
