If you only want the date portion use: =TODAY()

If you format the cell as Date3/14/01 the result of the NOW function should
display in the Date format. Can't think of why it wouldn't.

--
Biff
Microsoft Excel MVP


"Maperalia" wrote in message
...
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