View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
bobm bobm is offline
external usenet poster
 
Posts: 19
Default how do i convert a number stored as text to a numb in a vba loop

hello,

i have a question regarding excel giving the error that the number is stored
as text.

can i convert these cells using a for loop until the last row? i tried
multiplying the cell value by 1 in a for loop but this this did not seem to
work. i still get the green triangle next the cell indicating number stored
as text.

any help is appreciated.

bobm