that doesn't work. It still leaves the number with 1/2 next to it. Any
other ideas? Thanks

"Peter Jausovec" wrote:

Hi,

Change the cell formating to Number (right click on the cell and select
Format cells, in Number tab select Number under Category).

Hope this helps.
--
Best regards,
Peter Jaušovec
http://blog.jausovec.net
http://office.jausovec.net


"Jambruins" je napisal:

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.