fields formated as 3-8-18 autoformatting to date on when exported

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

have fields in third party program which when exported to Excel are
autoformatted to date. Ex: 3-8-18 autmatically becomes 3/18/2018.
How do I disable this? Can only export to Excel - program creates new
workbook.
 
Not knowing your exact procedure it's hard to be specific, but somehow in the
process try to format that column as TEXT, or append a leading apostrophe to
the strings to make Excel see them as text.

hth
Vaya con Dios,
Chuck, CABGx3
 
Format the colmun you exporting into as 'text' then try going 'data'...'text
to columns'...click next, then next again. You will then see a drop down
menu in the column data format area that contains date formats, select y/m/d
and it should display as you wish.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

numbers to dates 9
Disable auto (date) format? 3
Problem formatting dates from CSV file 2
Excel autoformatting dates 1
text to date when exporting from access to excel 3
how to get excel to combine numbers to a given total 3
Import to Formatted Worksheet 1
Import format and then exporting 2

Back
Top