| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vijay 3
I have a excel sheet with one column is date field.
My data is in the format of mm/dd/yyyy and my regional settings are dd/mm/yyyy can any one advice me how to convert the data in to above said format. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Vijay 3
Select the cells you want to change and right click - format - number -
custom and enter dd/mm/yyyy or mm/dd/yyyy which ever you want. Mike "vijaydsk1970" wrote: I have a excel sheet with one column is date field. My data is in the format of mm/dd/yyyy and my regional settings are dd/mm/yyyy can any one advice me how to convert the data in to above said format. |
Linear Mode
