Thread: How to display 12-12-34 as it is in excel worksheet?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
NAVEEN
 
Posts: n/a
Default How to display 12-12-34 as it is in excel worksheet?
Put ' infront of data

Type as follows:

' 12-23-34

Regards
NAVEEN

"Justin" wrote:

when i enter numbers in 12-23-34 format will convert into date format. I want
to display as it is. How to do this
Reply With QuoteReply With Quote