Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Datevlaue function/ day/month/year function
Hello
My PC is set up as UK region and hence displays dates as 20/01/06. However I have a spreadsheet sent from the US formatted as general and reflects 01/20/06 as the date. I am trying to use a vlookup where the dates match, I have tried format cells, date dd-mm-yy but this does not work it still shows 01/20/06. I have also tried to use datevalue, day, month, year functions (as a serial number) and then looking up those values. However they all return #value. Does anyone have any ideas how I can convert this date to UK date format? Any help is appreciated. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date & Time | New Users to Excel | |||
Conversion | Excel Worksheet Functions | |||
I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Find a Function to use accross different worksheets | Excel Worksheet Functions |