| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
why can't I change the date with find and replace in this formula
=GETPIVOTDATA("Sum of Reg $",'01-10-08
Summary'!$A$4,"Dept.",101,"Hourly/Salary","Salary") on the other worksheets I have for our various divisions I'm able to find 01-10-08 and replace with, for example, 01-25-08. When I try to do the same here it wants me to open a file and then won't open it either |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find and replace for date format | Excel Discussion (Misc queries) | |||
| Find Replace Formula | Excel Discussion (Misc queries) | |||
| Change Excel Find & Replace Options Defaults | Excel Discussion (Misc queries) | |||
| The Find or Replace will not work on a date. | Excel Discussion (Misc queries) | |||
| Find and replace of word causes change of font formatting | New Users to Excel | |||
Hybrid Mode
