File format

  • Thread starter TUNGANA KURMA RAJU
  • Start date
T

TUNGANA KURMA RAJU

I have 2 questions.
1.How to change excel file into csv file ?. For example how to convert my
excel file raju.xls to raju.csv.
2. One of my excel file while opening appearing as xxx,yy,ki,jj, like this
with commas between data.It is not appearing as column,row format.how to
retrive as default excel format?
 
B

Bob Phillips

TUNGANA KURMA RAJU said:
I have 2 questions.
1.How to change excel file into csv file ?. For example how to convert my
excel file raju.xls to raju.csv.
Click to expand...

Select CSV form the file types in the save dialog
2. One of my excel file while opening appearing as xxx,yy,ki,jj, like this
with commas between data.It is not appearing as column,row format.how to
retrive as default excel format?
Click to expand...

Look at Data>Text to Columns with a comma delimiter
 
Top