Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I need to be able to manipulate data, so that I have 1 column with either a
Date field, in dd/mm/yyyy format of a number to zero decimal points. I have tried formatting this column to text and linking the column to two other columns that are formatted in either date or numbers, but is simply pulls back the date in the standard numerical value. I have a standard =If formulae, which pulls back the data. Is there an precursor that can be added to the IF statement that will pull back the data in the correct format... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Function for 3 date columns | Excel Worksheet Functions | |||
merging columns - one date, one time | Excel Worksheet Functions | |||
Conditional formatting of date | Excel Discussion (Misc queries) | |||
Incorrect Date formatting | Excel Discussion (Misc queries) | |||
Despite formatting a column in Excel 2002 worksheet as Short Date. | Excel Discussion (Misc queries) |