LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 27th 06, 09:01 PM posted to microsoft.public.excel.misc
external usenet poster
First recorded activity by ExcelBanter: Nov 2006
Posts: 25
Default Formulas not evaluated, Formulas treated as strings


Here's the solution to a nasty user-induced 'bug' that ranks up there with
my having spent three hours bird dogging why my commands were not working on
an old IBM 370 mainframe in 1975 -- I had 'set uplow' during the session, and
my commands were lower case as I keyed them, no longer in upper case as I had
been accustomed to having the system do automatically for me.

A user had a spreadsheet whose

1) numbers were left justified, not right justified as is normal
2) formulas beginning with an '=' sign were treated as strings and not

In this case, check:

1. the format of the cells. the user's were 'Text', not 'General'. So of
course they'll be treated as text.

2. Tools Options, Error Checking tab. There is a setting to treat numbers
as text. Clear that.

3. Compounding this was an incorrect reference to a merged cell. If cells on
sheet A1 are merged, use =A1!C3, not =A1!C3:F3.

Bob Sullentrup

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
Countif formulas change after doing a sort Bob Smith Excel Worksheet Functions 3 January 4th 06 12:17 AM
Printing formulas TUNGANA KURMA RAJU Excel Discussion (Misc queries) 7 November 28th 05 08:29 AM
Array Formulas take waaaay too long... belly0fdesire Excel Worksheet Functions 7 August 8th 05 10:11 PM
Problem with named formula's nathan Excel Worksheet Functions 0 January 21st 05 05:07 PM
calculating formulas for all workbooks in a folder Chad Excel Worksheet Functions 3 November 13th 04 06:22 PM

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

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

About Us

"It's about Microsoft Excel"


Copyright © 2017