View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
kevcar40 kevcar40 is offline
external usenet poster
 
Posts: 78
Default convert a text string to a number

Hi
i have a column of data in the form of a string
ie 123 i want to convert this to a number
the problem is that the sting has a space at the beginning
How do i remove the space and convert this string to a number

thanks
kevin