LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 21
Default formulas appear in cell as entered..

whatever function (eg. "=sum(A1:A10)") I typed into the cell, the formula
just appeared as normal text, displaying exactly what I typed in.

how can I get it to work?

I do not think this is due to the manual calculation update option, as it
has been set to automatic..

any help is appreciated.. thanks!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel ignoring previously entered formulas mijoh Excel Worksheet Functions 3 April 24th 07 06:38 PM
Auto calculate formulas when new data is entered Cam1234 Excel Discussion (Misc queries) 6 February 15th 07 05:30 PM
Need cell formulas to return the day of every Monday in a month based on year entered mikeburg Excel Discussion (Misc queries) 3 June 14th 06 10:07 PM
#N/A Values : Returned by Formulas vs Entered Manually monir Charts and Charting in Excel 8 July 7th 05 01:16 AM
Formulas returning a blank if no data entered in one cell Mifty Jackson New Users to Excel 3 March 31st 05 04:37 PM


All times are GMT +1. The time now is 07:53 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"