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

Date Format Problem
 

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

Date Format Problem
 

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
"T. Valko" wrote:

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

Date Format Problem
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


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

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