i'm downloading data into an excel spreadsheet from
bloomberg. bloomberg is a financial data provider.

the download is giving me prices in general format that
look like this. 99-27 3/4, 98-18, 103-16, 99-00 1/2.

basically 99-27 3/4 is equal to 99.8671875. you take the
fraction and 27 3/4 which is equals 27.75 and divide that
by 32. that gives you .8671875

is there any function in excel that will help me covert
the general number into decimal format. i need to change
all the general numbers into decimal format.

tks.