Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |