| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
When entering numbers as text
I have several spreadsheets that have numbers entered as text. When I change
it to text it gives me a green tag which I have to select and then choose "Ignore error" to get it to disappear. Is there away to prevent that from occurring? It is a real nuisance to do that everytime I add numbers as text. |
|
#2
|
|||
|
|||
|
Hi!
Goto ToolsOptionsError Checking If you want to avoid all of those "lovely triangles", under Rules, uncheck everything. Biff "jmcme" wrote in message ... I have several spreadsheets that have numbers entered as text. When I change it to text it gives me a green tag which I have to select and then choose "Ignore error" to get it to disappear. Is there away to prevent that from occurring? It is a real nuisance to do that everytime I add numbers as text. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I convert numbers stored as text with spaces to numbers | Excel Discussion (Misc queries) | |||
| How to reformat numbers stored as text (apostrophe at beginning) | Excel Discussion (Misc queries) | |||
| How to convert Excel imported numbers from text to numbers? | Excel Discussion (Misc queries) | |||
| Converting Numbers to Text properly | Excel Discussion (Misc queries) | |||
| excel - numbers as text | New Users to Excel | |||
Linear Mode
