Home |
Search |
Today's Posts |
#1
|
|||
|
|||
concatenate with numbers
Hello,
I am using the concatenate function in my worksheet. =CONCATENATE("TOTAL QUOTE : £",H10,"") I want the cost to have commas as in the original cell but it just appears as a number. I've tried Cell("contents",H10) but get the same result. any ideas on how to get the commas? Thanks |
#2
|
|||
|
|||
="TOTAL QUOTE : "&TEXT(H10,"£#,##0")
-- HTH Bob Phillips "Ciara" wrote in message ... Hello, I am using the concatenate function in my worksheet. =CONCATENATE("TOTAL QUOTE : £",H10,"") I want the cost to have commas as in the original cell but it just appears as a number. I've tried Cell("contents",H10) but get the same result. any ideas on how to get the commas? Thanks |
#3
|
|||
|
|||
Thank you!
"Bob Phillips" wrote: ="TOTAL QUOTE : "&TEXT(H10,"£#,##0") -- HTH Bob Phillips "Ciara" wrote in message ... Hello, I am using the concatenate function in my worksheet. =CONCATENATE("TOTAL QUOTE : £",H10,"") I want the cost to have commas as in the original cell but it just appears as a number. I've tried Cell("contents",H10) but get the same result. any ideas on how to get the commas? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Checking Winning Numbers in the Lottery. | Excel Discussion (Misc queries) | |||
Concatenate text and numbers? | Excel Worksheet Functions | |||
Match Last Occurrence of two numbers and Return Date | Excel Worksheet Functions | |||
Count and Sum Total occurrances of two specific numbers | Excel Worksheet Functions | |||
Use numbers in CONCATENATE formula without getting error | Excel Worksheet Functions |