Japanese to English Date Conversion Problem

B

BigNate

I have a question regarding getting the correct date to display fro
imported files. I download process logs from a piece of Japanes
equipment and import them into Excel as a comma delimited file so tha
they can be accessed easily from a network computer. The problem
have is that the date is in YYYY/MM/DD format, and excel will onl
display the date correctly if I change the regional settings i
Windows' control panel. Is there a way to correct this with a macro o
function without having to change my regional settings? Thanks for th
help
 
D

David McRitchie

Hi "BigNate >" <<[email protected]> ,
When you import a comma delimited file (.csv) you get the
file import wizard only if you change the file extension first
to something like .txt

When you open the file from Excel (with your .txt extension),
you reply delimited and choose either comma or semi-colon
depending on the file. When asked to define the columns
select the column and choose ymd for the (year month day) format.
 
B

BigNate

Thanks for the info David. I tried what you said, and it still came u
with the wrong date and year. It seems like the number that is used t
represent the date is different for the different formats. Your metho
works when I have the regional settings set to Y/M/D, but not th
normal American M/D/Y. If you have any additional info, I would reall
appreciate it. Thanks again
 
Top