Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Excel date format
Name: fungustango Date: October 7, 2003 at 12:16:37 Pacific OS: XP CPU/Ram: AMD 512
Comment:
When i try to format a date it appears as a line of hash keys, when the cursor is floated over the cell a pop up box tells me negative dates or times are displayed as #########. Can anybody help?
Name: Mike Date: October 7, 2003 at 22:58:33 Pacific
Reply:
Hi there,
Excel doens't support negative dates, meaning when you substract today's date from yesterday's date , it will give an error. don't have a clue what you are making, so if i had some more info i could help more. There are ways around this problem.
With regards
Mike
0
Response Number 2
Name: Stuart Date: October 14, 2003 at 15:01:02 Pacific
Reply:
You can subtract todays date from yesterdays date without error. It will produce a negative number, after all dates are just numbers like any other - unless you have entered the date as a string which is bad practice.
The ####### indicate the column width is to norrow for the data being displayed. Widen the columm to see what the data is.
Stuart
0
Response Number 3
Name: SJ Date: October 31, 2003 at 10:27:48 Pacific
Reply:
I have a .CSV file with a column of dates in the US format - mm/dd/yyyy. How do I convert this to Canadian format of dd/mm/yyy?
Summary: http://www.computing.net/answers/of... I have got same issue in the link above, how can I change date format in Excel 2003 to dd/mm/yy (28/03/09),,,,there is no such an option in Format --> Cell --> "...
Summary: When I try to format a cell(s)I can open Format but when I click on cells it won't open. I get no error message. I have had other strange things happen in excel - date format disappears and the curr...
Summary: Last week while entering data into Excel, I noticed that it started making me enter the date in opposite (example, instead of entering 07 10 for July 10th, it made me type in 10 07 to get the final en...
0 
MS Excel and XLL files
