Link to home
Start Free TrialLog in
Avatar of Patrick O'Dea
Patrick O'DeaFlag for Ireland

asked on

Converting to Date Upon Upload from Third Party Software

Hi,

This is no doubt a familiar problem.
I have found some solutions on the web but none quite works for me.

I have an Add-in in Excel which facilitates the loading of data into Excel from a financial package.

Column "A" contains data which is sometimes interpreted as a DATE by Excel.
How do I stop this?
Avatar of Patrick O'Dea
Patrick O'Dea
Flag of Ireland image

ASKER

... As the OP I have a solution.
Before I import the data into Excel ... I have set column a to be a "text" field and when imported it does NOT convert to a date.

However, I would appreciate any other suggestions???

THanks,
ASKER CERTIFIED SOLUTION
Avatar of Ryan
Ryan
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thx,

Amazing how this problem has been around from years!