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.