imported data

  1. R

    Dates imported as text?

    When I import a report into Excel, often the dates come over and some of them are text while others are recognized dates. I think it because the order of the months and days is not what Excel is expecting. See image: Does anyone know the best way to fix this in Excel as oppose to on the...
  2. C

    Pivot Table Text Error

    Okay, this one is slightly complicated. I have a program that I use at work that I download a report from, and that report is TOTALLY unhelpful, so it gives you an option to produce all the information in the database in an excel import. With me so far? I didn't think so...But onwards...

Some videos you may like

This Week's Hot Topics