View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marcelo Marcelo is offline
external usenet poster
 
Posts: 1,047
Default Changing time and text format

http://www.asap-utilities.com/?cf89A... Wm6I2bdXkgcx

check the asap utilities site, they have an addin that could solve your
problems
hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Jamie" escreveu:

I have data that is in a word document and it is written "37 Minutes". When
i copy that data into a cell in excel I want it to just show "37". I have
tried different formatiing option but to no avail. I also have a field
written out "1 Hour and 33 minutes" and want to convert that as well.

Any ideas?