View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
greg greg is offline
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