| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
dates
How can I change the date format 01/01/08 to 010108
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
dates
Select the cell and give it a custom format of mmddyy. Select Format Cells
on the Number tab, select Custom in the Type box, enter mmddyy OK. Hope this helps, Hutch "rebecca" wrote: How can I change the date format 01/01/08 to 010108 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
dates
"Tom Hutchins" wrote: Select the cell and give it a custom format of mmddyy. Select Format Cells on the Number tab, select Custom in the Type box, enter mmddyy OK. Hope this helps, Hutch "rebecca" wrote: How can I change the date format 01/01/08 to 010108 I ALSO NEED TO CHANGE THE FORMAT INTO A TEXT CELL. WHEN I TRY TO DO THIS IT GIVES ME A NUMBER THAT EXCEL RECOGINZES AS A SUM NUMBER (I THINK) |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
dates
Hi Rebecca
Try =SUBSTITUTE(TEXT(A1,"dd/mm/yy"),"/","") -- Regards Roger Govier "rebecca" wrote in message ... "Tom Hutchins" wrote: Select the cell and give it a custom format of mmddyy. Select Format Cells on the Number tab, select Custom in the Type box, enter mmddyy OK. Hope this helps, Hutch "rebecca" wrote: How can I change the date format 01/01/08 to 010108 I ALSO NEED TO CHANGE THE FORMAT INTO A TEXT CELL. WHEN I TRY TO DO THIS IT GIVES ME A NUMBER THAT EXCEL RECOGINZES AS A SUM NUMBER (I THINK) |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
dates
Try
=SUBSTITUTE(TEXT(A1,"dd/mm/yy"),"/","") Why not just this instead... =TEXT(A1,"ddmmyy") -- Rick (MVP - Excel) |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
dates
Because I like to make things more complicated than they need be, Rick<bg
-- Regards Roger Govier "Rick Rothstein" wrote in message ... Try =SUBSTITUTE(TEXT(A1,"dd/mm/yy"),"/","") Why not just this instead... =TEXT(A1,"ddmmyy") -- Rick (MVP - Excel) |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
dates
LOL
-- Rick (MVP - Excel) "Roger Govier" <roger@technology4unospamdotcodotuk wrote in message ... Because I like to make things more complicated than they need be, Rick<bg -- Regards Roger Govier "Rick Rothstein" wrote in message ... Try =SUBSTITUTE(TEXT(A1,"dd/mm/yy"),"/","") Why not just this instead... =TEXT(A1,"ddmmyy") -- Rick (MVP - Excel) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Identifying unique dates in a range of cells containing dates... | Excel Discussion (Misc queries) | |||
| Identifying unique dates within a range of cells containing dates | Excel Discussion (Misc queries) | |||
| need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
| Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
| Charting data against dates where dates are not at fixed intervals | Charts and Charting in Excel | |||
Linear Mode
