View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Andy Andy is offline
external usenet poster
 
Posts: 6
Default cannot convert text string into value

Dear all,

I can convert a text string "12345" into the value 12,345.00 by using
Value(text).
However when I copy a text string "12345" from the monthly e-bill statement
and using value(text) to convert it, it only returns a #value! error.
How can I convert that string into value?

thanks


Andy