Thread: write date into file in YYYY.MM.DD format
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Lars Schouw Lars Schouw is offline
external usenet poster
  
Posts: 19
Default write date into file in YYYY.MM.DD format
Thanks Ron,

=TEXT(TODAY(),"yyyy.mm.dd")

seems to do the stunt..

I need this format since some application have depends on it.. I agree
ISO format is much nicer,
Reply With QuoteReply With Quote