ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   "Additonal Numbers adjacent to it" (https://www.excelbanter.com/excel-worksheet-functions/125688-additonal-numbers-adjacent.html)

MarkS

"Additonal Numbers adjacent to it"
 
On some of the cells in my Spreadsheet (not all) a Diamond shape appears and
clicking on it displays the following message:

The formula in this cell refers to a range that has additional numbers
adjacent to it.

What is the cause of this message and how can I prevent it from being
displayed.

Thanks in advance



Roger Govier

"Additonal Numbers adjacent to it"
 
Hi Mark

ToolsOptionsError CheckingUntick Enable background error checking

--
Regards

Roger Govier


"MarkS" wrote in message
...
On some of the cells in my Spreadsheet (not all) a Diamond shape
appears and
clicking on it displays the following message:

The formula in this cell refers to a range that has additional numbers
adjacent to it.

What is the cause of this message and how can I prevent it from being
displayed.

Thanks in advance





MarkS

"Additonal Numbers adjacent to it"
 
Many thanks for your help
Mark

"Roger Govier" wrote:

Hi Mark

ToolsOptionsError CheckingUntick Enable background error checking

--
Regards

Roger Govier


"MarkS" wrote in message
...
On some of the cells in my Spreadsheet (not all) a Diamond shape
appears and
clicking on it displays the following message:

The formula in this cell refers to a range that has additional numbers
adjacent to it.

What is the cause of this message and how can I prevent it from being
displayed.

Thanks in advance







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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com