View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave[_7_] Dave[_7_] is offline
external usenet poster
 
Posts: 1
Default Text to a number

I received a large csv file from our vendor and I would like to use Excel
functions.
I currently have a cell that has the following value:

19:00

I would like convert this to the number 19. There are also blank spaces in
front of the value above.

Thank you for any help you can give, Dave