| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I concatenate a number and preserve the formatting? | Excel Worksheet Functions | |||
| Concatenate Function | Excel Discussion (Misc queries) | |||
| Concatenate question | Excel Worksheet Functions | |||
| Concatenate | Excel Discussion (Misc queries) | |||
| Concatenate cells without specifying/writing cell address individually | Excel Discussion (Misc queries) | |||
Linear Mode
