Formula displays instead of value

R

Ron

Corporate sends Excel spreadsheets that do not allow entry of a formula. If a
formula is entered it shows with the leading = sign. I cannot get it to
display the value of the formula. Have tried formatting the cells to number,
but that does not work. If I copy the formula to a blank spreadsheet it
displays the value properly. Please help with suggestions. thanks,
Ron
 
F

Frank Kabel

Hi
after changing the format to 'Number' or 'General' re-enter the
formula. If this does not help check under 'Tools - Options - View'
that 'formulas' is unchecked
 
Top