Tab delimited file differs in 2 Excel applications - Help please

M

malycom

Hi

I have set up a report that I export as a tab delimited file. When I open
the file in Excel on my PC, the date format is all aligned and set to
dd/mm/yyyy

If I try to open the same tab delimited file on a colleagues PC, the date
format goes to pieces. Some dates are d/d/yy, others are dd/mm/yyy - There
are also time elements in some dates - There is no consistency. Even if I
try and format the cells to show a dd/mm/yyyy, it does not format the column.

The date column is actually the most important column in this particular
cas as we run a macro that calculates 10 year anniversaries based on todays
date compared to set up date.

Any ideas on how I can get around this.

Thanks in advance

Malcolm Davidson
 
D

Dave Peterson

My bet is there is a difference between your Windows setting for displaying
dates.

In win98, I'd use:
windows start button|settings|Control panel|regional settings applet
Date tab
And verify that I had the same order mdy or dmy or whatever.

But I wouldn't bother trying to match. If there's a change, then I'm screwed
up.

I'd rename the file to .txt (if it's not already)
then File|open

Then when I see the text importer wizard, I could specify the correct date
format for each field.
 
Top