| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
USA to UK Dates
I have a list of data extracted from elsewhere and the dates are in USA
format i.e. mm/dd/yyyy Can excel swap this around to UK format dd/mm/yyyy ? thanks in advance -- Vass ................................................ Now: YZF-R1, CBR1100xx-x Then: A100, MBX80, XL125, CB400, FZR600, CBR600Fv |
|
#2
|
|||
|
|||
|
Hi, Format the dates to dd/mm/yyyy Highlight the dates Format Cells Number tab Date choose the one you need If it is not in there go to Custom and put dd/mm/yyyy in the space provided under Type. HTH. -- greg7468 ------------------------------------------------------------------------ greg7468's Profile: http://www.excelforum.com/member.php...fo&userid=9031 View this thread: http://www.excelforum.com/showthread...hreadid=381899 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using dates for x-axis values as string instead of creating a scale | Charts and Charting in Excel | |||
| Finding dates within a date range | Excel Worksheet Functions | |||
| Finding Dates in a date range | Excel Discussion (Misc queries) | |||
| Formating Dates for production schedule | Excel Discussion (Misc queries) | |||
| due dates | New Users to Excel | |||
Linear Mode
