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: Edwards Tax Date: June 1, 2005 at 16:13:31 Pacific OS: Windows 2000 CPU/Ram: 512
Name: Jennifer SUMN Date: June 1, 2005 at 16:55:02 Pacific
Reply:
What format is the cell in now?
0
Response Number 2
Name: Edwards Tax Date: June 1, 2005 at 17:05:24 Pacific
Reply:
Thanks for your quick reply. There is no format. Just general number. The cell is now showing as "20040314". I tried to go to command cell format and date. But it's not giving me anything but this - ######. Any tips ?
0
Response Number 3
Name: rhawk7938 Date: June 1, 2005 at 17:43:00 Pacific
Reply:
Click format, cells, number tab, click date and select the type you want.
0
Response Number 4
Name: Edwards Tax Date: June 1, 2005 at 17:48:14 Pacific
Reply:
That's what I did. I selected "Date" type. However, I am not getting any number. All I get is this sign ########### ! If you type 20040314 in any cell, then do the steps you said to get 03/14/2004, you will not go anywhere.
0
Response Number 5
Name: rhawk7938 Date: June 1, 2005 at 22:35:23 Pacific
Reply:
Enter the date as X/XX/XX or you can use dashes, then hit enter it will appear as you selected in the type of date in format.
0
Response Number 6
Name: Edwards Tax Date: June 2, 2005 at 08:10:34 Pacific
Reply:
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,000 date again with dashes. Do you know any other way to format simple number that already there into a date format?
0
Response Number 7
Name: rhawk7938 Date: June 2, 2005 at 10:08:49 Pacific
Reply:
Okay. Now I understand what you are trying to do. The only way I know of is to use VBA code. You would have to convert the raw number into a format that Excel would recognize as a date 20051001 into 01/10/2005 for instance. Otherwise Excel is just going to assume it is the number 20051001 and since the cell is looking for a date for a date it will just show #########.
Maybe someone alse knows a way around this, but I can't think of anything else that would work.
0
Response Number 8
Name: Edwards Tax Date: June 2, 2005 at 10:20:29 Pacific
Reply:
Thanks ! Could you let me know how to do that in VBA. I never had to do it. Is VBA part of Excel ?
0
Response Number 9
Name: rhawk7938 Date: June 2, 2005 at 11:02:18 Pacific
Reply:
Try this formula:
=LEFT(A1,4)&"/"&(MID(A1,5,2)&"/"&RIGHT(A1,2))
0
Response Number 10
Name: Edwards Tax Date: June 2, 2005 at 11:11:32 Pacific
Reply:
It's working. Thanks a lot. I love this forum. I guess I get to keep my job then:-))
0
Response Number 11
Name: Joost Date: June 2, 2005 at 12:35:49 Pacific
Reply:
Use the following and y'll get the answer in the dateformat you put into your computer (; could be , at your end) =DATE(LEFT(A1;4);MID(A1;5;2);RIGHT(A1;2))
It's more or less the same as rhawk's
0
Response Number 12
Name: vmoney Date: July 28, 2005 at 11:10:09 Pacific
Reply:
OK we have the same problem. I need a little step by step explanation about where to put the formula. We have a column of dates, how do we set up the spreadsheet to compute them all?
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: 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 fo...
0 
