| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I ignore the "Number stored as text" error message permane.
I have numbers stored as text. I don't consider this to be an error, but
Microsoft Excel does, and puts a little green triangle in the upper left corner of the cell. I can click to ignore the error, thereby hiding or removing the green triangle, but after I save the document (type xml) and retrieve it, the error returns. How do I permanently disable the green triangle from appearing. -- Kevin |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I ignore the "Number stored as text" error message permane.
Tools/ Options/ Error checking...
Disable options to suit your preferences. -- David Biddulph "reston33" wrote in message ... I have numbers stored as text. I don't consider this to be an error, but Microsoft Excel does, and puts a little green triangle in the upper left corner of the cell. I can click to ignore the error, thereby hiding or removing the green triangle, but after I save the document (type xml) and retrieve it, the error returns. How do I permanently disable the green triangle from appearing. -- Kevin |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I ignore the "Number stored as text" error message permane.
toolsoptionserror checking tabremove tick in the number stored as text box
-- John MOS Master Instructor Office 2000, 2002 & 2003 Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "reston33" wrote: I have numbers stored as text. I don't consider this to be an error, but Microsoft Excel does, and puts a little green triangle in the upper left corner of the cell. I can click to ignore the error, thereby hiding or removing the green triangle, but after I save the document (type xml) and retrieve it, the error returns. How do I permanently disable the green triangle from appearing. -- Kevin |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deleted the pivot table - continue to get the "overlap" error message | Excel Discussion (Misc queries) | |||
| Adding more than 3 cells (2003)produces "0" but no error message | Excel Worksheet Functions | |||
| "unable to paste link" Excel error message | Excel Discussion (Misc queries) | |||
| excel 2003 "french "always reloads with error message when closin | Excel Discussion (Misc queries) | |||
| Error message "Not enough system resources to display completely." | Excel Discussion (Misc queries) | |||
Linear Mode
