CLR and Dave, they did not work either. I used the paste special command and
pasted the numbers in in html format. Would that be the problem? Thanks

"CLR" wrote:

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.