importing question

  • Thread starter Thread starter oTTO
  • Start date Start date
O

oTTO

how can i import from another file like csv, without losing my cell
formatting in excel
 
oTTO said:
how can i import from another file like csv, without losing my cell
formatting in excel
Click to expand...

Open the CSV file in a new workbook. Then highlight and copy the data that
you want from the CSV file. Go to your current workbook and do Paste Special
Values. This will allow you to import the data while maintaining your
Click to expand...
current cell formatting (hopefully, I understood your question correctly).
 
that worked thank you!

Open the CSV file in a new workbook. Then highlight and copy the data that
you want from the CSV file. Go to your current workbook and do Paste Special
current cell formatting (hopefully, I understood your question correctly).
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Which is the best MBOX Converter Tool different formats conversion? 4
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Differences Between Two Spreadsheets ? 1
References to cells in another workbook 3
How to Export Gmail Emails to PST Format? 4
Hide non-printing characters. 5
Stopping excel from converting numbers into dates on import 10
Excel And Notepad 3

Back
Top