Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help Convert "MM/DD/YYYY" to "YY:DDD"
Hello,
Please help: I have a column of dates in the MM/DD/YYYY" format How can I convert it to the "YY:DDD" format? For example, 12/31/2005 would become 05:365 and 01/01/1985 would become 85:01 Thank you! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help Convert "MM/DD/YYYY" to "YY:DDD"
On Tue, 24 Jan 2006 02:44:01 -0800, Sam wrote:
Hello, Please help: I have a column of dates in the MM/DD/YYYY" format How can I convert it to the "YY:DDD" format? For example, 12/31/2005 would become 05:365 and 01/01/1985 would become 85:01 Thank you! =TEXT(A1,"yy")&":"&TEXT(A1-DATE(YEAR(A1),1,0),"00") --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert decimal degree (lattitude/longitude) into Degree, | Excel Discussion (Misc queries) | |||
Convert my entire spreadsheet from inches to centimeters | Excel Discussion (Misc queries) | |||
CONVERT Function Disappered in Excel | Excel Discussion (Misc queries) | |||
convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) | |||
Convert Numeric into Text | Excel Worksheet Functions |