Excel format
Closed
D
-
Dec 10, 2008 at 04:55 PM
sheryljohnson Posts 5 Registration date Saturday November 1, 2008 Status Member Last seen December 15, 2008 - Dec 15, 2008 at 05:22 AM
sheryljohnson Posts 5 Registration date Saturday November 1, 2008 Status Member Last seen December 15, 2008 - Dec 15, 2008 at 05:22 AM
Hello,
I have a spreadsheet with a column which is supposed to represent dates.
However cells are of the format of 25 12 08 - this example represents 25 December 2008 in European format.
However the data sorts as numbers rather than a date.
I want to import the spreadsheet into a database.
I have converted the cells to the format 25.12.08 but this does not help.
How do I convince Excel that the cells contain dates. I have 2500 rows in the spreadsheet, so manual changing would be rather tedious!
Your help would be appreciated.
D
I have a spreadsheet with a column which is supposed to represent dates.
However cells are of the format of 25 12 08 - this example represents 25 December 2008 in European format.
However the data sorts as numbers rather than a date.
I want to import the spreadsheet into a database.
I have converted the cells to the format 25.12.08 but this does not help.
How do I convince Excel that the cells contain dates. I have 2500 rows in the spreadsheet, so manual changing would be rather tedious!
Your help would be appreciated.
D
Related:
- Which example represents cell data with the date format applied to it?
- How to change date format in excel - Guide
- Kingston format utility - Download - Storage
- Tmobile data check - Guide
- Format factory - Download - Other
- Apply the moderate effect smartart style - Guide
1 response
sheryljohnson
Posts
5
Registration date
Saturday November 1, 2008
Status
Member
Last seen
December 15, 2008
4
Dec 15, 2008 at 05:22 AM
Dec 15, 2008 at 05:22 AM
You have "converted the cells to the format 25.12.08" - thats almost correct but not totally - convert them to the format 25/12/08 and I believe that will do it.
(you know, the simplest way to convert it is by using the "find and replace" tool, and all *one space* character with / character)
(you know, the simplest way to convert it is by using the "find and replace" tool, and all *one space* character with / character)
