Thread: when I enter my date it transfers
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default when I enter my date it transfers
Not without VBA or a formula to translate. You can't do it just with cell
formatting.
--
David Biddulph

"Zoe's Grams" <Zoe's Grams @discussions.microsoft.com wrote in message
...
Is it possible to enter 010510 and have it post as 01/05/10 and is it
possible to enter 1330 and it post as 13:30? Thank you very much


Reply With QuoteReply With Quote