In which case, try Tools/ Options/ View: uncheck Formulas.
Or Control ` (perhaps the key to the left of 1) to toggle this function.
--
David Biddulph

"Sher" wrote in message
...
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.