Thread: Data Entry problem
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
MartinW MartinW is offline
external usenet poster
  
Posts: 860
Default Data Entry problem
Hi Jason,

The colon tells excel the input is time, so to excel 1:500
is 1 hour 500 minutes.

If you type an apostrophe before your input like '1:500
it will stay as text.

HTH
Martin


Reply With QuoteReply With Quote