number formatting question
 

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

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Ryan Case" wrote in message ...
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