LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 59
Default 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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 - Macro (VB) code for arrow down & arrow up Grindy Excel Discussion (Misc queries) 5 January 28th 09 04:30 AM
How to format Green conditionally b1 if a1 is only Green? narnimar Excel Discussion (Misc queries) 4 October 13th 08 04:27 PM
Blue to Green and Back to Green Loadmaster Excel Discussion (Misc queries) 5 August 15th 08 12:33 AM
Green arrow in cells [email protected] Excel Worksheet Functions 3 January 31st 08 10:38 AM
why dont shift+arrow or ctrl+arrow work in 2007 Naguib Excel Discussion (Misc queries) 1 July 24th 07 04:40 PM


All times are GMT +1. The time now is 11:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"