MrExcel.com - Your One Stop for Excel Tips & Solutions

A real poser ... time export format

Posted by Max Gattie on May 15, 2000 1:03 AM

Hi, I am having a problem with time formats in excel97. Basically, what appears in the cells is not what exports. In the cells my time is in hh.mm.ss.000 and when I export it appears at hh.mm.ss. I want my data to export as hh.mm.ss.000.

This is a real poser - I can make no sense of it whatsoever. If you think you can help I can send you the excel file and a jpeg which describes the problem more fully. Mail to maxgattie@eudoramail.com.

Thanks!

Posted by Ivan Moala on May 15, 2000 1:40 AM

Max
You may not have the Data cells formated to your
Time format on your original sheet ??
ie. the data has exported over BUT your Data cell
is not formated as HH.mm.ss.000

Ivan

Posted by Max Gattie on May 15, 2000 4:57 AM

No ... cell and formula bar data don't match

Ivor, I tried that and it isn't the problem.

When I highlight data in the cells, the data in the formula bar does not match. I have never come across this before. Do you have any ideas?

Posted by Ivan Moala on May 15, 2000 6:27 AM

Re: No ... cell and formula bar data don't match


How are you exporting the data ?

Ivan


Posted by Max Gattie on May 15, 2000 7:06 AM

Some answers here ..?

What I'm trying to do is open an Excel97 document in FilemakerPro. This works, but hh.mm.ss.000 changes to hh.mm.ss. I have the same problem opening the file in Word, so this doesn't look like a problem with FMPro.

If I save as comma-delimited in Excel it opens correctly in other applications - as hh.mm.ss.000.

What I want to know is - do I have to go the route of opening in Excel and saving as comma-delimited, or is there a way to make the excel file open in another app?

Incidentally, I found out why the cell and formula bar data don't match (hh.mm.ss.000 in cells, hh.mm.ss in formula bar). This is because the Excel formula bar is limited to the time settings in the control panel (which do not allow for hh.mm.ss.000).

This is all very inconvenient, but the comma-delimited workaround does seem to work. It just means I have to bypass Excel entirely.

Max