View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default IS POSIBLE TO ADD TEXT IN TO A CELL WHIT TIME FORMAT?

Sounds like your code/formula is expecting a number, but you are entering
text, so bang....error.
Your code/formula needs to deal with it.
On the worksheet, maybe you ISERROR or code need error trap and/or data
check, IsNumeric .
Post what you have.

NickHK

"aloncillo" wrote in message
...
i got a time sheet but wen a entry for example rest i get error value