number formatting question

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
 
D

David McRitchie

Hi Ryan,

Change period to space using Ctrl+H
then format as General or other number format of your choice,
which might be #,###.0000
 
Top