importing question

  • Thread starter Thread starter oTTO
  • Start date Start date
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...
 
Back
Top