| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
"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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
"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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
| Replace Old Part Numbers with New Part Numbers in a Macro. | Excel Discussion (Misc queries) | |||
| conditional formatting | Excel Worksheet Functions | |||
| How to generate sets of random numbers without having duplicates | Excel Worksheet Functions | |||
| Why are 1/2 my numbers imported as text and the rest as numbers? | Excel Discussion (Misc queries) | |||
Hybrid Mode
