Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
freezing dates
Hi Guys
I need to get excel to enter to-days date and then freeze this date so is does not update later. I dont want to copy-paste special-values. I need to have it in a function statement. I tried =IF(C17="not completed","",TEXT(TODAY(),"d/mm/yyyy;@")) but it still updates even though the cell format is text. Bob Phillips was helpfull byt it still doesnt work Any other suggestions please? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Freezing on SumIf | Excel Discussion (Misc queries) | |||
freezing panes | Setting up and Configuration of Excel | |||
freezing a row | Setting up and Configuration of Excel | |||
Freezing Panes | Excel Discussion (Misc queries) | |||
Freezing one cell | Excel Worksheet Functions |