| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COMBINING TWO COLUMNS THAT ARE CURRENCY
I have 2 columns that I want to merge together and I used =A2&B2 and that
part works, but it won't let me format it back to currency? If you merge two columns together and then later want to merge another one into the already merged column, is that what's messing it up? Thanks Donna |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
COMBINING TWO COLUMNS THAT ARE CURRENCY
Look in the help index for DOLLAR
-- Don Guillett Microsoft MVP Excel SalesAid Software "Donna" wrote in message ... I have 2 columns that I want to merge together and I used =A2&B2 and that part works, but it won't let me format it back to currency? If you merge two columns together and then later want to merge another one into the already merged column, is that what's messing it up? Thanks Donna |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
COMBINING TWO COLUMNS THAT ARE CURRENCY
The & operator returns the two numbers as text.
To see some formatting.............. =TEXT(A2&B2,"$#,##0.00") BTW...........you are not merging columns...........you are combining columns. "merging" is a dirty word around here<g Gord Dibben MS Excel MVP On Mon, 24 Aug 2009 14:19:13 -0700, Donna wrote: I have 2 columns that I want to merge together and I used =A2&B2 and that part works, but it won't let me format it back to currency? If you merge two columns together and then later want to merge another one into the already merged column, is that what's messing it up? Thanks Donna |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combining Text from 2 Columns into 1 then Deleting the 2 Columns | Excel Worksheet Functions | |||
| Combining columns | Excel Discussion (Misc queries) | |||
| Combining Columns | Excel Discussion (Misc queries) | |||
| Adding currency broken in two columns? | Excel Worksheet Functions | |||
| combining columns all the way down | Excel Discussion (Misc queries) | |||
![Donna[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
