Patrick O'Dea
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thx,
Amazing how this problem has been around from years!
Amazing how this problem has been around from years!
ASKER
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,