View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
taj taj is offline
external usenet poster
 
Posts: 5
Default Remove a character from a number field

Im working with a column of various hh:mm data. Example of data:

29.28h
344.25h
26.75h
7.25h
0h
12.5h
0h
14.5h
13.25h

As you can see, there is no fixed decimal place. Does any one know how I may
be able to move the €˜h from the end of the numbers for the column?

Thanks in advance,