format_text

[john]

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"

 

[PCLIVE]

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

 

[Ron Rosenfeld]

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

 

[Reitanos]

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]