View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bruce D. Bruce D. is offline
external usenet poster
 
Posts: 14
Default Format Text to number

I am using excel 2007 and I am creating a macro that will count the number of
account numbers in a column. The problem is that the account numbers are
stored as text not number. This prevents the count() function from working.
Is there a way to get this accomplished.

Thanks!
--
Bruce