LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
wvc wvc is offline
external usenet poster
 
Posts: 1
Default How do I fix: cell won't calculate because it is a constant?

When I export a table from a third party application into an Excel file,
formulae are not calculated. The formulae are displayed instead of the value
of the formula. I do not have this option selected (to display formulae
instead of values). When I "evaluate formula" the message says that "The
cell currently being evaluated contains a constant."
 
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
text in a cell invoke constant date in another cell - how Frode Inge Helland Excel Discussion (Misc queries) 1 September 18th 08 09:25 PM
How can I remove a constant from a cell? ac Excel Worksheet Functions 2 April 29th 08 07:48 PM
How do I add a formula to a cell containing a constant value Shana77 Excel Discussion (Misc queries) 2 September 11th 07 09:24 PM
Constant cell Aurora Excel Worksheet Functions 1 February 14th 06 03:08 PM
the cell currently being evaluated contains a constant Barrie Wells Excel Worksheet Functions 2 June 2nd 05 12:59 PM


All times are GMT +1. The time now is 03:37 AM.

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"