Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
dates appear as error hashes
When I type dates in cells on an Excel spreadsheet they become a series of
hashes. But other dates of the same format in other workbooks are fine. Why does this error keep on occuring. I think may be the cells are not in the right format for me to add dates. Can i change this?? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
dates appear as error hashes
Hi
Try widening the columns. Does this resolve the problem? Regards Roger Govier pembers wrote: When I type dates in cells on an Excel spreadsheet they become a series of hashes. But other dates of the same format in other workbooks are fine. Why does this error keep on occuring. I think may be the cells are not in the right format for me to add dates. Can i change this?? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
dates appear as error hashes
The number hash usually means that the cell is not wide enough to display the information. Try resizing the columns - that should work. Good luck Tony -- y_not ------------------------------------------------------------------------ y_not's Profile: http://www.excelforum.com/member.php...o&userid=19947 View this thread: http://www.excelforum.com/showthread...hreadid=487960 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
PivotTables - Group Dates, excluding dates | Excel Discussion (Misc queries) | |||
Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
2 digit year in dates return 19xx not 20xx | Excel Discussion (Misc queries) | |||
Default Dates | Excel Discussion (Misc queries) | |||
Formating Dates for production schedule | Excel Discussion (Misc queries) |