format_text
 

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"

format_text
 

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"

format_text
 

On Wed, 28 May 2008 08:56:06 -0700, john
wrote:

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"

=text(value*1000,"0")

will do that. Are you sure that's what you want?
--ron

format_text
 

Do you actually want to convert it to text?

If so, the second argument defines how the text will be displayed:
=TEXT(A3*1000,"$0") [this generates $1009 as a piece of text]
If you don't need a dollar sign, etc you can use =TEXT(A3*1000,"0") to
get just the number.

If not, you can try something like this:
=A3*1000 [this generates 1009 as a value that
can be used in other formulas]


On May 28, 11:56 am, john wrote:
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"