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 Richard Your Own Question

Richard
Richard, Software Specialist
Category: Microsoft Office
Satisfied Customers: 31327
Experience:  Over 15 year experience resolving Microsoft Office Issues
32989067
Type Your Microsoft Office Question Here...
Richard is online now
A new question is answered every 9 seconds

I am doing a spreadsheet and on one line in a column I have

Customer Question

Hello,
JA: Hello. How can we help?
Customer: I am doing a spreadsheet and on one line in a column I have the companies Fein number. This number will not stay in a text format.
JA: What kind of computer do you have?
Customer: pc
JA: Have you installed any updates recently?
Customer: No. Do I need to get the new Office 365?
JA: Anything else you want the microsoft office expert to know before I connect you?
Customer: Will that help my problem. The file is a CSV.
Submitted: 26 days ago.
Category: Microsoft Office
Expert:  Richard replied 26 days ago.

Hi there and welcome

Can you Save the the sheet as Excel and not CSV. Then open the Excel document, convert the whole sheet to text format, and save as .csv.

It should keep them as text format.

Let me know how you go please.

Expert:  Richard replied 26 days ago.

I can also do these steps for you, and have made a request via Additional Services. This is optional, and if you choose to do this, I can, with your permission, remote into your computer while you watch and do all these steps (and deal with any problems that arise during them) for you. Or if you do not choose to take this service, we can continue here. This is no problem at all. Just let me know please.