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: 1
Default Formulas displayed in all of my cells

I had a completed worksheet that was working properly. Somehow, the sheet
was changed so that every cell displays the formula instead of the result.
Date cells display the absolute date number. I don't know how it happened,
and I don't know how to get it back. I can not simply reformat the cell, and
I don't see any sheet formatting functions or view functions that would
globally fix.
 
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
data not displayed in cells jez35000 Excel Discussion (Misc queries) 9 December 2nd 06 10:31 AM
Formulas Are Displayed and are not calculating Connie Excel Discussion (Misc queries) 1 October 20th 06 03:11 AM
I've changed the way my formulas are displayed !! Dave Excel Worksheet Functions 4 September 4th 06 04:47 PM
Calculating Cells n% displayed in a cell? Hannibal Excel Worksheet Functions 0 November 2nd 05 02:36 PM
Automatic linewrap with formulas displayed Christopher R. Lee Excel Worksheet Functions 1 February 17th 05 12:56 AM


All times are GMT +1. The time now is 11:39 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"