| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trouble with concatenation number format
Hi, I am having trouble with a concatenation formula. I have $1,000,000 in
cell A1 and 75% in cell B1. Once the numbers are concatenated I want them appear in cell C1 exactly as they are. The problem is that when I concatenate them the result is as follows: 1000000, 0.75. How can I format them to appear with the $ and % signs? So far I have: =CONCATENATE(A1,", ",B1) Thanks in advance for any help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trouble with concatenation number format | Excel Worksheet Functions | |||
| Trouble with concatenation number format | Excel Worksheet Functions | |||
| format/concatenation | Excel Worksheet Functions | |||
| Conditoinal format trouble | Excel Discussion (Misc queries) | |||
| marrying a rounded number to concatenation. | New Users to Excel | |||
Threaded Mode
