Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cannot format date at all
I have exported from SAP system some data into excel.
I need to work out the week number in some dates 12.03.2007 format, for some reason weeknum will not work at all, I thought maybe if I changed the format to 12 march 2007 it would work (did on another sheet) but I cannot, no matter what change the format, it's as if it's locked. How? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Code Date Format Depending on Computer format | Excel Discussion (Misc queries) | |||
Convert date from text format to date format | Excel Discussion (Misc queries) | |||
Convert date + time text format to date format | Excel Worksheet Functions | |||
Can I change a date with no format (20051111) to date format? | New Users to Excel | |||
Excel 2000 date format cannot be set to Australian date format | Excel Discussion (Misc queries) |