View original (French)

Excel date cell format not working

Solved
julylu -  
 julylu -
Hello,

I imported an Excel 2007 file from the office to my home (Excel 2003) and I notice that I cannot convert my columns to date format. They only appear as numbers. However, I can see the date in my taskbar...

Do you have a solution?

Thank you!

Julie

config>Windows XP / Firefox 3.6.13</config>

4 answers

Answer 1 / 4
leph Posted messages 691 Status Member 26
 
Hello Julylu,

How did you convert from Excel 2007 to 2003?

Best regards,
Leph
--

The quote
Well, uhh, I don’t know...
0
julylu
 
Hello,

I logged in remotely and only sent my file via Outlook and then saved it in Excel 2003.
0
Answer 2 / 4
Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
 
Good evening
perhaps your numbers are in text format.
try this
in a cell enter 1 and copy it
select your date field
special paste / Multiply
if that doesn't work, place a sample of your problem here:
http://www.cijoint.fr
and come back to provide the link given by the site.
looking forward to hearing from you
best regards

--
Let's ask ourselves if we are not alone in understanding what is being explained?
0
julylu
 
Okay, thank you, I will try and get back to you on that.
0
Answer 3 / 4
leph Posted messages 691 Status Member 26
 
Good evening Julylu,

To convert from Excel 2007 to 2003, you must first open the file in Excel 2007, then click on the Office icon at the top left and select "Save As," then choose "Excel Workbook 97/2003."

And there, the conversion is fine and everything works.

Best regards,
Leph
--

The quote
Well, uhh, I don’t know...
0
Answer 4 / 4
julylu
 
Thank you all for your help. I logged back into the office and saved the file again, making sure to choose Excel 2003. Then I emailed it to myself via Outlook, and I can finally see my date columns! Great team! Thank you and have a nice day xxx
0