Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to convert date field to number value
Hi, I need to convert an Excel date field such as "9/26/1964" to the value of "19640926". Is this possible? Thanks -- landj68 ------------------------------------------------------------------------ landj68's Profile: http://www.excelforum.com/member.php...o&userid=28004 View this thread: http://www.excelforum.com/showthread...hreadid=475075 |
#2
|
|||
|
|||
Using a custom format for the cell you can rearrange the order. By going into the Format menu then Cell menu. In the Number tab scroll to custom and input "yyymmdd" without the quotes and the cell will display the date in the order you wanted. -- goober ------------------------------------------------------------------------ goober's Profile: http://www.excelforum.com/member.php...o&userid=19838 View this thread: http://www.excelforum.com/showthread...hreadid=475075 |
#3
|
|||
|
|||
sorry that was supose to be "yyyymmdd" good luck. -- goober ------------------------------------------------------------------------ goober's Profile: http://www.excelforum.com/member.php...o&userid=19838 View this thread: http://www.excelforum.com/showthread...hreadid=475075 |
#4
|
|||
|
|||
Thanks for your help I really appreciate it. It worked great. -- landj68 ------------------------------------------------------------------------ landj68's Profile: http://www.excelforum.com/member.php...o&userid=28004 View this thread: http://www.excelforum.com/showthread...hreadid=475075 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Customized Date Format | Excel Worksheet Functions | |||
NETWORKDAYS - Multiple Date Selection | Excel Discussion (Misc queries) | |||
How to convert date to text | Excel Discussion (Misc queries) | |||
How do I convert a number formated as a date to text in Excel? | Excel Discussion (Misc queries) | |||
How do I convert a Julian date into a regular date? | Excel Discussion (Misc queries) |