View Single Post
 
Old 01-30-2009, 02:44 PM
caholmes caholmes is offline Windows Vista Office 2007
Advanced Beginner
 
Join Date: Dec 2008
Location: Sydney, Australia
Posts: 54
caholmes is on a distinguished road
Default Simple formula fix

The cells are formatted as Text. You need to format them back to general (Format >> Format Cells) and then click into the formula bar for each formula and then hit enter. This will refresh them and excel will now see them as formulas.
Reply With Quote