LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 622
Default formulae corruption in excel

Numerous cells
have a small green triangle in the top left of the cell.

This may be a separate problem. The green triangle indicates a
potential formatting error. If you select one of these, you should
have a little menu suddenly appear right next to it. Go into that and
it will tell you what Excel thinks is wrong, usually a number that is
formatted as text or other similar issue. Some of these are just
cosmetic, others can affect calculation.

You can pick which errors Excel will highlight with the green triangle
in Options on the Error Checking tab.


 
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 2007 data corruption using sort within a filter. J_Harrington Excel Discussion (Misc queries) 4 November 14th 07 07:43 PM
excel corruption problem while copying tabs [email protected] Excel Discussion (Misc queries) 0 August 6th 07 11:27 PM
Excel file corruption when opened with Word? nfe Excel Discussion (Misc queries) 5 May 4th 06 10:15 AM
Corruption in Excel? Dudley Excel Discussion (Misc queries) 0 October 25th 05 03:36 PM
Excel Menu Corruption Dave White Excel Discussion (Misc queries) 5 March 15th 05 10:46 PM


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