Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
green arrow for error
Hello,
I am inserting numbers in a column. The numbers are formated like ####. So: 0001 0002 .... 0300 etc... however once my code runs, Each of the cells has the green arrow errors. It wants to convert to a number. So 0001 would go to 1. Is there a way to make these arrows not appear when dropping in the text? Is there a way after inserting the text to place an ignore error on the cell through code? etc... thanks for any help |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
green arrow for error
Click on Tools|Options|Error checking
Uncheck the errors you don't want flagged--including "Number stored as text" You could record a macro when you do this manually and add it to your code if you really wanted. greg wrote: Hello, I am inserting numbers in a column. The numbers are formated like ####. So: 0001 0002 ... 0300 etc... however once my code runs, Each of the cells has the green arrow errors. It wants to convert to a number. So 0001 would go to 1. Is there a way to make these arrows not appear when dropping in the text? Is there a way after inserting the text to place an ignore error on the cell through code? etc... thanks for any help -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
green arrow for error
OK,
Seems like the code would be Application.ErrorCheckingOptions.NumberAsText = False thanks "Dave Peterson" wrote in message ... Click on Tools|Options|Error checking Uncheck the errors you don't want flagged--including "Number stored as text" You could record a macro when you do this manually and add it to your code if you really wanted. greg wrote: Hello, I am inserting numbers in a column. The numbers are formated like ####. So: 0001 0002 ... 0300 etc... however once my code runs, Each of the cells has the green arrow errors. It wants to convert to a number. So 0001 would go to 1. Is there a way to make these arrows not appear when dropping in the text? Is there a way after inserting the text to place an ignore error on the cell through code? etc... thanks for any help -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
green arrow for error
Remember that this is an application setting. If you share your macro with
others, they may not like the choice you made. greg wrote: OK, Seems like the code would be Application.ErrorCheckingOptions.NumberAsText = False thanks "Dave Peterson" wrote in message ... Click on Tools|Options|Error checking Uncheck the errors you don't want flagged--including "Number stored as text" You could record a macro when you do this manually and add it to your code if you really wanted. greg wrote: Hello, I am inserting numbers in a column. The numbers are formated like ####. So: 0001 0002 ... 0300 etc... however once my code runs, Each of the cells has the green arrow errors. It wants to convert to a number. So 0001 would go to 1. Is there a way to make these arrows not appear when dropping in the text? Is there a way after inserting the text to place an ignore error on the cell through code? etc... thanks for any help -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 - Macro (VB) code for arrow down & arrow up | Excel Discussion (Misc queries) | |||
How to format Green conditionally b1 if a1 is only Green? | Excel Discussion (Misc queries) | |||
Blue to Green and Back to Green | Excel Discussion (Misc queries) | |||
Green arrow in cells | Excel Worksheet Functions | |||
why dont shift+arrow or ctrl+arrow work in 2007 | Excel Discussion (Misc queries) |