I really can't find any extra character, this is not the case as you
mention.
thanks David


Andy




"David Biddulph" <groups [at] biddulph.org.uk .. .
You've probably got non-printing characters as well as your string 12345.
Get rid of those extra characters.
--
David Biddulph

"Andy" wrote in message
...
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