I need to copy data from a cell into a string. The data is numeric.
I want to format this number in the string. How can I do that without
writing my own complicated format function?

For example:

A1: 12345
B1: "You have " & A1 & " outstanding tickets."

I want B1 to say "You have 12,345 outstanding tickets" not "You have
12345 outstanding tickets".

Thanks.

Edward

="You have "&TEXT(A1,"#,##0")&" outstanding tickets"

you can do the same for any other formatting like percentage and currency
etc


="You owe me "&TEXT(A1,"$#,##0")&" and you better cough it up or you'll end
up as fish food"


--


Regards,


Peo Sjoblom


"Edward" wrote in message
ups.com...
I need to copy data from a cell into a string. The data is numeric.
I want to format this number in the string. How can I do that without
writing my own complicated format function?

For example:

A1: 12345
B1: "You have " & A1 & " outstanding tickets."

I want B1 to say "You have 12,345 outstanding tickets" not "You have
12345 outstanding tickets".

Thanks.

Edward

="You have "&TEXT(A1,"#,##0")&" outstanding tickets."


--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Edward" wrote in message
ups.com...
I need to copy data from a cell into a string. The data is numeric.
I want to format this number in the string. How can I do that without
writing my own complicated format function?

For example:

A1: 12345
B1: "You have " & A1 & " outstanding tickets."

I want B1 to say "You have 12,345 outstanding tickets" not "You have
12345 outstanding tickets".

Thanks.

Edward

You can use the TEXT function to do that.

="You have "&TEXT(A1,"#,##0")&" outstanding tickets."

Rick


"Edward" wrote in message
ups.com...
I need to copy data from a cell into a string. The data is numeric.
I want to format this number in the string. How can I do that without
writing my own complicated format function?

For example:

A1: 12345
B1: "You have " & A1 & " outstanding tickets."

I want B1 to say "You have 12,345 outstanding tickets" not "You have
12345 outstanding tickets".

Thanks.

Edward

Maybe

="You have " &TEXT(A1,"#,###") & " outstanding tickets"

Mike

"Edward" wrote:

I need to copy data from a cell into a string. The data is numeric.
I want to format this number in the string. How can I do that without
writing my own complicated format function?

For example:

A1: 12345
B1: "You have " & A1 & " outstanding tickets."

I want B1 to say "You have 12,345 outstanding tickets" not "You have
12345 outstanding tickets".

Thanks.

Edward

="some text " & TEXT(A1,"#,##0") & " other text"

where A1 contains the value.
--
Gary''s Student - gsnu200753


"Edward" wrote:

I need to copy data from a cell into a string. The data is numeric.
I want to format this number in the string. How can I do that without
writing my own complicated format function?

For example:

A1: 12345
B1: "You have " & A1 & " outstanding tickets."

I want B1 to say "You have 12,345 outstanding tickets" not "You have
12345 outstanding tickets".

Thanks.

Edward

try
= "You have " & text(A1,"#,##0") & " outstanding tickets."


"Edward" wrote:

I need to copy data from a cell into a string. The data is numeric.
I want to format this number in the string. How can I do that without
writing my own complicated format function?

For example:

A1: 12345
B1: "You have " & A1 & " outstanding tickets."

I want B1 to say "You have 12,345 outstanding tickets" not "You have
12345 outstanding tickets".

Thanks.

Edward

Thanks.

On Nov 1, 10:46 am, "Peo Sjoblom" wrote:
="You have "&TEXT(A1,"#,##0")&" outstanding tickets"

you can do the same for any other formatting like percentage and currency
etc

="You owe me "&TEXT(A1,"$#,##0")&" and you better cough it up or you'll end
up as fish food"

--

Regards,

Peo Sjoblom

"Edward" wrote in message

ups.com...



I need to copy data from a cell into a string. The data is numeric.
I want to format this number in the string. How can I do that without
writing my own complicated format function?

For example:

A1: 12345
B1: "You have " & A1 & " outstanding tickets."

I want B1 to say "You have 12,345 outstanding tickets" not "You have
12345 outstanding tickets".

Thanks.

Edward- Hide quoted text -

- Show quoted text -

Or you could ignore the formula in cell B1 and give cell A1 the custom format
of:

"You have" #,### "outstanding tickets."

Then just type the number in cell A1 as normal (the formatting will add the
rest).