Date Format Problem

  • Thread starter Thread starter Maperalia
  • Start date Start date
M

Maperalia

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
 
If you only want the date portion use: =TODAY()

If you format the cell as Date>3/14/01 the result of the NOW function should
display in the Date format. Can't think of why it wouldn't.
 
Biff;
Thanks very much for your quick response. The formula is working
PERFECTLY!!!!!!.
I have one last question. I format the date to 01/22/09 and I am getting
01/22/2009. I can life wioth that. It is no a problem.
The macro I have reads the information from this cell (the date) and
writting to AutoCAD. So I am thinking that AUtoCAD is doing something that
make this change. However, I am OK with tghis result.

Thanks again for your help.

Maperalia
 
Back
Top