View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
prahz prahz is offline
external usenet poster
 
Posts: 18
Default Number stored as text error message

I have created a macro in vba to input a "string of numbers" into a
cell.
-Some of the numbers in the string have leading zeros so I have
formatted the cell type as "text."
-Excel gives me this green tick mark at the top right corner of the
cell showing a Number Stored as Text error.
-How do I suppress the green tick mark from not ever coming up?

Does anybody know how to do this?