Thread
:
Change 1/2 to .5
View Single Post
#
1
Posted to microsoft.public.excel.misc
Jambruins
Posts: n/a
Change 1/2 to .5
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.
Reply With Quote