How to format a Date to a Real Numerical Date?

S

Shi

Hi,

I have a regular stock chart, just like any other stock
charts in the planet. The Horizontal Axis is the Date.
Usually, the Date will be displayed as 07/08/04 (mm/dd/yy)
format. How to format this Date to a Real Numerical Date?

VBA code or manual solutions are both acceptable.

Thank you,
 
N

Norman Jones

Hi Shi

Try using ths Clng conversion function.

For example, from the intermediate window:

?CLng(#07/09/2004#)
38237
?CLng(date)
38177
 
S

Shi

Norman,

Thank you very much for your help.

Is this 38237 equivalent to which "Category" under the
Menu [Format]-[Format Cells]-[Number Tab]-[Category]?

===============
General
Number
Date
Text
Special
Custom
===============
 
N

Norman Jones

Hi Shi,

To display a date manually as its serial value, use the general format or
number format and set decimal places to 0.


---
Regards,
Norman



Shi said:
Norman,

Thank you very much for your help.

Is this 38237 equivalent to which "Category" under the
Menu [Format]-[Format Cells]-[Number Tab]-[Category]?

===============
General
Number
Date
Text
Special
Custom
===============


-----Original Message-----
Hi Shi

Try using ths Clng conversion function.

For example, from the intermediate window:

?CLng(#07/09/2004#)
38237
?CLng(date)
38177

---
Regards,
Norman






.
Click to expand...
Click to expand...
 
S

Shi

Norman,

This is really a big help. Thanks a lot.


-----Original Message-----
Hi Shi,

To display a date manually as its serial value, use the general format or
number format and set decimal places to 0.


---
Regards,
Norman



Norman,

Thank you very much for your help.

Is this 38237 equivalent to which "Category" under the
Menu [Format]-[Format Cells]-[Number Tab]-[Category]?

===============
General
Number
Date
Text
Special
Custom
===============


-----Original Message-----
Hi Shi

Try using ths Clng conversion function.

For example, from the intermediate window:

?CLng(#07/09/2004#)
38237
?CLng(date)
38177

---
Regards,
Norman



Hi,

I have a regular stock chart, just like any other stock
charts in the planet. The Horizontal Axis is the Date.
Usually, the Date will be displayed as 07/08/04 (mm/dd/yy)
format. How to format this Date to a Real Numerical Date?

VBA code or manual solutions are both acceptable.

Thank you,


.
Click to expand...
Click to expand...


.
Click to expand...
 
Top