If you just need to remove the decimal and leave the value as text, then you
could use a substitute function.

=SUBSTITUTE(A2,".","")

HTH,
Paul

--

"john" wrote in message
...
I am trying to use the funcation =TEXT(value,format_text) and I do not know
what to do with the format_text. I am trying to convert a number
"1.009"
to a text of "1009"