Yes, I did enter to re-confirm the formula and nothing has changed.

"Max" wrote:

Aha, as mentioned in my response, you must:
" ... then click inside the formula bar
and press ENTER to re-confirm the formula."

Did you do the above?

Formatting alone will not suffice. You must re-confirm the formula to
re-trigger it
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:16,200 Files:354 Subscribers:53
xdemechanik
---
"Sher" wrote:
Good Morning Max -

Made the change formula cell to General and still no change. Not sure why
this isn't working.