Thread: Date Format Problem
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
maperalia maperalia is offline
external usenet poster
  
Posts: 258
Default Date Format Problem
I have a cell setup with "=now()" formula. and I formatted to be 01/22/09.
However, I got 01/22/09 3:00PM instead.
Can you tell what is wrong?

Thanks in advance.
Maperalia
Reply With QuoteReply With Quote