Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to format a Date to a Real Numerical Date?
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, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to format a Date to a Real Numerical Date?
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to format a Date to a Real Numerical Date?
Hi Shi
Try using ths Clng conversion function. For example, from the intermediate window: ?CLng(#07/09/2004#) 38237 ?CLng(date) 38177 --- Regards, Norman "Shi" wrote in message ... 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, |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to format a Date to a Real Numerical Date?
Hi Shi,
In my example, both results should (of course!) be 38177. --- Regards, Norman "Norman Jones" wrote in 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to format a Date to a Real Numerical Date?
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 "Shi" wrote in message ... 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, . |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to format a Date to a Real Numerical Date?
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" wrote in message ... 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 "Shi" wrote in message ... 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, . |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to format a Date to a Real Numerical Date?
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 "Shi" wrote in message ... 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 "Shi" wrote in message ... 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, . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
making numerical date return mmmm format | Excel Worksheet Functions | |||
Date format from numbers to a real date? | Excel Worksheet Functions | |||
date in text format as a real date | Excel Worksheet Functions | |||
Help: How do I convert a text date into a real date format | Excel Worksheet Functions | |||
real date for column | New Users to Excel |