View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave O Dave O is offline
external usenet poster
 
Posts: 427
Default Display results of formulas not the actual formula

Hi, Bridget-
It sounds like that cell is formatted as text, instead of formatted at
"General" or a specific number format. If you'll right-click the cell,
select Format Cells from the box that appears, and select the proper
format from the list.