number formatting question

  • Thread starter Thread starter Ryan Case
  • Start date Start date
R

Ryan Case

I have csv files from another program that I want to bring into excel.
One of the columns contains mixed numbers in the format of 15.3/16. I
want to have this changed to 15.1875. Any help is greatly appreciated.

Ryan
 
Hi Ryan,

Change period to space using Ctrl+H
then format as General or other number format of your choice,
which might be #,###.0000
 
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

Problem formatting dates from CSV file 2
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
numbers convert to formula in csv 1
.csv to .txt 2
Can Not get cell to accept any format change! Source from html 1
text converts to scientific 1
bank transfer error numbers display from workbook to csv 1
Modify number display 4

Back
Top