Thread: editing numbers
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
stremetzky stremetzky is offline
external usenet poster
 
Posts: 21
Default editing numbers

I have imorted values from another program. Imported values are in
000:00 form (000 for hours and 00 for minutes). If there is less than
100 hours the value is still not treated as [h]:mm. For example:

029:15

How can I erase the first one or two zeros??

stremetzky