Try this in a helper column and copied down................

=SUBSTITUTE(A1,CHAR(189),".5")*1

Vaya con Dios,
Chuck, CABGx3



"Jambruins" wrote:

I have copied a bunch of data into a spreadsheet and column G has numbers in
it. Some of the numbers are in this format 5½, 6½, etc. Is there a way to
change the 5½ to 5.5 and 6½ to 6.5, etc.? Thanks.