Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing date format
Month by month I have to work a spreadsheet containing values that should be
in dd/mm/yyyy format but as I get this page from an internal program, I use to get mm/dd/yyyy. The real problem comes when I try to change mm/dd/yyyy to dd/mm/yyyy as the first one is considered in General Number and it is not possible to change it to any of the above mentioned (as Numbers). What I have to do every month is to separate the text into columns, export the result to word, replace Tabs for / and copy the result back to the excel spreadsheet. Is there any way to do this conversion in a simple way? Just to reinforce: I'm not able to change it directly in excel as it seems the column takes a special programming info outside my control. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing date format
Is there any way to do this conversion in a simple way?
Try Data Text to Columns to convert it all at one go into dates recognized by Excel Select the col of "dates", click Data Text to Columns Click Next Next In step 3, under Col data format: Check "Date", then select the format from the droplist, eg: MDY Click Finish Now you should be able to format the dates to taste -- Max Singapore http://savefile.com/projects/236895 Downloads:18,100 Files:360 Subscribers:56 xdemechanik --- "PaulinaDi" wrote: Month by month I have to work a spreadsheet containing values that should be in dd/mm/yyyy format but as I get this page from an internal program, I use to get mm/dd/yyyy. The real problem comes when I try to change mm/dd/yyyy to dd/mm/yyyy as the first one is considered in General Number and it is not possible to change it to any of the above mentioned (as Numbers). What I have to do every month is to separate the text into columns, export the result to word, replace Tabs for / and copy the result back to the excel spreadsheet. Is there any way to do this conversion in a simple way? Just to reinforce: I'm not able to change it directly in excel as it seems the column takes a special programming info outside my control. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing date format
Excellent. I got was I just wanted.
Do you know why I get those numbers with no format so I have to do this step? Thanks a lot "Max" wrote: Is there any way to do this conversion in a simple way? Try Data Text to Columns to convert it all at one go into dates recognized by Excel Select the col of "dates", click Data Text to Columns Click Next Next In step 3, under Col data format: Check "Date", then select the format from the droplist, eg: MDY Click Finish Now you should be able to format the dates to taste -- |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing date format
Excellent. ..
That's good. Take a moment to press the "Yes" button below Do you know why I get those numbers with no format so I have to do this step? It probably has to do with the output from that internal program. What's more important is that you know how to deal with it. -- Max Singapore http://savefile.com/projects/236895 Downloads:18,100 Files:360 Subscribers:56 xdemechanik --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
date format keeps changing | Excel Discussion (Misc queries) | |||
changing date format | Excel Worksheet Functions | |||
Changing the date format | Excel Discussion (Misc queries) | |||
Changing Date Format | Excel Discussion (Misc queries) | |||
Changing Date Format | Excel Worksheet Functions |