How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask John D Your Own Question

John D
John D, Bachelor's Degree
Category: Microsoft Office
Satisfied Customers: 9666
Experience:  Bachelor of Science - Engineering Consultant
53785
Type Your Microsoft Office Question Here...
John D is online now
A new question is answered every 9 seconds

I use Quickbooks 2006 Pro and often export reports to MS Excel

Resolved Question:

I use Quickbooks 2006 Pro and often export reports to MS Excel (2002) to do analysis, graphs etc.
Some numerical data is always exported as numbers and others as text.
The latter must then be re-typed to do calculations, sorts etc.
What can I do to have all numerical data exported as numbers?
Jan in South Africa
Submitted: 4 years ago.
Category: Microsoft Office
Expert:  Danielle-Mod replied 4 years ago.

Hi, I’m a moderator for this topic and I wonder whether you’re still waiting for an answer. If you are, please let me know and I will do my best to find an Expert to assist you right away. If not, feel free to let me know and I will cancel this question for you. Thank you!

Customer: replied 4 years ago.
Hi Danielle,
No, I have not received any response yet.
Regards.
Jan
Expert:  John D replied 4 years ago.
Hi,

Are you able to export your quickbooks report into a text file or a csv file?
Customer: replied 4 years ago.

Hi John,

Only export options available are .csv file, new Excel workbook and existing Excel workbook. Ie text file export not available.

Exporting into a .csv file and then importing that into Excel works and numbers are exported as numbers, both in the .csv and subsequent Excel files, thank you.

Any reason why this does not work when exporting directly into Excel?

Regards.

Fellow engineer Jan

Expert:  John D replied 4 years ago.

Hi Jan

 

Sorry for the delay in responding. I just got the notification that you have replied (the site was down several times in the past few days)

 

When importing csv files Excel automatically detects that the file is essentially a text file and uses the text import wizard to parse the data. In doing so it determines which field is text and which field is number and applies the proper format accordingly

 

Hope this helps. Let me know if you have any questions, and thank you for clicking Accept if you are satisfied with the answers

 

 

John D, Bachelor's Degree
Category: Microsoft Office
Satisfied Customers: 9666
Experience: Bachelor of Science - Engineering Consultant
John D and 2 other Microsoft Office Specialists are ready to help you