S Sandi Jun 3, 2004 #1 the formula remains as text in the field ie ='filetracker'!C26 This only happens occasionally - anyone know why?
the formula remains as text in the field ie ='filetracker'!C26 This only happens occasionally - anyone know why?
K kkknie Jun 3, 2004 #2 If the cell is formatted as text, this will happen. Change to genera and reenter the formula and it should work.
If the cell is formatted as text, this will happen. Change to genera and reenter the formula and it should work.
T Tom Ogilvy Jun 3, 2004 #3 If the formula references a cell that is formatted as text this can also happen.
S sandi Jun 3, 2004 #4 -----Original Message----- If the formula references a cell that is formatted as text this can also happen. -- Regards, Tom Ogilvy . Thanks! Click to expand...
-----Original Message----- If the formula references a cell that is formatted as text this can also happen. -- Regards, Tom Ogilvy . Thanks! Click to expand...