Help with CONCATENATE!
 

I use the Concatenate function to write some notes to a report I print in
excel. One of the notes reads " The total number of people to enter was
1234". Where the number 1234 is referenced from another cell.

How can I get the note to display the number with a comma separating the
thousands i.e. as 1,234. The referenced cell is formatted this way.

Thanks in advance to anyone who knows this!

Help with CONCATENATE!
 

One way, assuming the number is in A1:
=" The total number of people to enter was "&TEXT(A1,"#,##0")
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Nic" wrote:
I use the Concatenate function to write some notes to a report I print in
excel. One of the notes reads " The total number of people to enter was
1234". Where the number 1234 is referenced from another cell.

How can I get the note to display the number with a comma separating the
thousands i.e. as 1,234. The referenced cell is formatted this way.

Thanks in advance to anyone who knows this!

Help with CONCATENATE!
 

Maybe this...........

="The total number of people to enter was
"&INT(A1/1000)&","&A1-INT(A1/1000)*1000

Vaya con Dios,
Chuck, CABGx3


"Nic" wrote in message
...
I use the Concatenate function to write some notes to a report I print in
excel. One of the notes reads " The total number of people to enter was
1234". Where the number 1234 is referenced from another cell.

How can I get the note to display the number with a comma separating the
thousands i.e. as 1,234. The referenced cell is formatted this way.

Thanks in advance to anyone who knows this!

Help with CONCATENATE!
 

Good one Max, mine only works up to 999,999............yours is much better!

Vaya con Dios,
Chuck, CABGx3


"Max" wrote in message
...
One way, assuming the number is in A1:
=" The total number of people to enter was "&TEXT(A1,"#,##0")
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Nic" wrote:
I use the Concatenate function to write some notes to a report I print
in
excel. One of the notes reads " The total number of people to enter was
1234". Where the number 1234 is referenced from another cell.

How can I get the note to display the number with a comma separating the
thousands i.e. as 1,234. The referenced cell is formatted this way.

Thanks in advance to anyone who knows this!

Help with CONCATENATE!
 

Chuck, Thanks for compliment <g
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"CLR" wrote in message
...
Good one Max, mine only works up to 999,999............yours is much
better!

Vaya con Dios,
Chuck, CABGx3

Help with CONCATENATE!
 

Thanks Max,
very neat solution - and so quick!
Nic

"Max" wrote:

One way, assuming the number is in A1:
=" The total number of people to enter was "&TEXT(A1,"#,##0")
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Nic" wrote:
I use the Concatenate function to write some notes to a report I print in
excel. One of the notes reads " The total number of people to enter was
1234". Where the number 1234 is referenced from another cell.

How can I get the note to display the number with a comma separating the
thousands i.e. as 1,234. The referenced cell is formatted this way.

Thanks in advance to anyone who knows this!

Help with CONCATENATE!
 

You're welcome, Nic !
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Nic" wrote in message
...
Thanks Max,
very neat solution - and so quick!
Nic