View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Torero Torero is offline
external usenet poster
 
Posts: 4
Default Number Stored as text Error

I'm trying to write a macro but one column show those little green things
that shows that I have an Error (Number Stored as text ). I don't know a lot
of VB so I'm recording and touching here and there the VB. I cannot record
the comand that changes it to number when I click in the little thing in the
cell that contains the error. If I go to format cell and change it to number
the error stays there. The problem is that if I have that error VLOOKUP does
not work properly. Does anybody could understand what I tried to say? Can
somebody help me?

Thanks,

Marcelo