| 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 | |||
Hybrid Mode
