Previous Topic Next Topic

Date not showing up as a date???

Closed
phaney - 3 Feb 2015 à 12:21
BrianGreen Posts 1005 Registration date Saturday 17 January 2015 Status Contributor Last seen 30 September 2021 - 3 Feb 2015 à 18:09
Hello,
I have entered & formatted a column as a date but shows up as a 5 digit number. I followed your instructions and it still showing up as a 5 digit number in the cell. It is entered as a date (ie 04/03/1991) and is showing up as a number in the cell (33331). Please help

Patty


2 responses

Réponse 1 / 2
BrianGreen Posts 1005 Registration date Saturday 17 January 2015 Status Contributor Last seen 30 September 2021 149
3 Feb 2015 à 12:37
I cant see the instructuions you were given previously as it looks like you have started a new thread. Sorry if I repeat what has already been stated by others.

Right click the cell you want to show as a date.
Choose "Format Cells"
Choose date from the left hand list.
Choose the way you want the date to display in the right hand list.
Press the "OK" button.

Hope this helps.
phaney
3 Feb 2015 à 12:52
I have done that and I have also gone to data and text to columns to reset the column as a date and nothing seems to be working unless I manually put a space in front each of the actual entered dates. Which defeats the purpose of being able to format the cells. Thanks for the quick response though! I appreciate any help I can get.
Réponse 2 / 2
BrianGreen Posts 1005 Registration date Saturday 17 January 2015 Status Contributor Last seen 30 September 2021 149
3 Feb 2015 à 13:48
Here is a solution by Karl some time ago. I hope it still holds true ...

Karl- Oct 19, 2010 09:30PM

I have had this problem for a long time and the only solution I have found is this.
1) (Save As) a Tab Deliminated.txt file.
2) Open New Excel
3) Open File and choose Tab Deliminated Option.
4) Go to each Date column and select it and chose Date DMY, MDY(Whichever) format.
5) Select Finish.
All dates should now format ok.
phaney
3 Feb 2015 à 17:53
Thanks Brian,

Unfortunately, I think the file is corrupted. I copied and pasted it into a new file and it corrected whatever was wrong. Thanks again.

Patty
BrianGreen Posts 1005 Registration date Saturday 17 January 2015 Status Contributor Last seen 30 September 2021 149
3 Feb 2015 à 18:09
So you are all done now?