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.
Date format in Excel
Name: Dhananjay Date: February 10, 2009 at 23:00:08 Pacific OS: Windows XP Subcategory: Microsoft Office
Comment:
wheni am entering 6/30/2005 in my excel sheet it is appearing as 38533 (i guess numeric value of date) however in function bar it appears correct as 6/30/2005. I made changes in cell format to date format but still its not working, can you help?
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: 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...
Summary: Thats a good idea If you input the data by yourself. But I have a file that has over 10,000 date in the format I mentioned, which is 20040314 without any dash or anything. I do not want to input 10,00...
