Solved

Converting to Date Upon Upload from Third Party Software

Posted on 2014-01-30
3
128 Views
Last Modified: 2014-01-30
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?
0
Comment
Question by:Patrick O'Dea
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 

Author Comment

by:Patrick O'Dea
ID: 39820682
... 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,
0
 
LVL 13

Accepted Solution

by:
Ryan earned 500 total points
ID: 39820793
Its hard to tell what an add-on might do. It could be the add-on tries to figure out the datatype and theres little you can do, or it can be that once the data is on the sheet excel does the datatyping.

Typically setting the format of the column which will have Data look a likes to be text, before  importing.  

If you'd like to cleanup your solution, then I might suggest creating a macro that redefines the datatype as you're doing, then calls the add-on.
0
 

Author Closing Comment

by:Patrick O'Dea
ID: 39822838
Thx,

Amazing how this problem has been around from years!
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question