LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Formulas display 0 instead of answer

When I type in a valid formula, a 0 appears instead of the result. If I copy
a formula from a different cell, the copied formula is correct, but the
result is the same as the cell I copied from.

Some setting seems to have changed on my spreadsheet that will not calculate
formulas.
 
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
can I use 2 formulas in 1 cell and display both results chris New Users to Excel 4 March 30th 06 12:26 PM
how to display formulas on the sheet flat6 Excel Worksheet Functions 8 February 18th 05 05:31 AM
Display answer only in another cell of one containing a formula Mally Excel Discussion (Misc queries) 5 January 21st 05 01:07 PM
how do i display formulas in only certain cells? mototrile_x Excel Worksheet Functions 4 November 3rd 04 10:10 AM
Combine & Display “Fixed” & “Automatically Updated” Date Parts texcel Excel Worksheet Functions 1 November 1st 04 05:38 PM


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

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

About Us

"It's about Microsoft Excel"