| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I format text so that when the formula delivers the mixeddata, it looks right
I'm using one formula to bring data from 2 cells (ranges actually)
into one cell. The data is mixed; text with $X.00. When the data is delivered, the number is just an integer, no currency formatting. A B Item Description and Amount "Book 5" =LOOKUP($E5,Items.xls!DataID,ItemDesc)&CHAR(10)&LO OKUP($E5,Items.xls! DataID,ItemPrice) Can someone suggest a way to format the amount in the 'B' column to look like money? Many thanks- Chrism |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I format text so that when the formula delivers the mixeddata, it looks right
=YourFirstHalfFormula & char(10) & text(yoursecondformula, "$#,##0.00")
Chrism wrote: I'm using one formula to bring data from 2 cells (ranges actually) into one cell. The data is mixed; text with $X.00. When the data is delivered, the number is just an integer, no currency formatting. A B Item Description and Amount "Book 5" =LOOKUP($E5,Items.xls!DataID,ItemDesc)&CHAR(10)&LO OKUP($E5,Items.xls! DataID,ItemPrice) Can someone suggest a way to format the amount in the 'B' column to look like money? Many thanks- Chrism -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| format text color within formula | Excel Worksheet Functions | |||
| Formula fails if cells text format | Excel Discussion (Misc queries) | |||
| How do I format text that is part of a formula? | Excel Discussion (Misc queries) | |||
| Offset delivers value error with Named range | Excel Worksheet Functions | |||
| Display Format with Text & Formula | Excel Worksheet Functions | |||
Linear Mode
