How do I format text so that when the formula delivers the mixeddata, it looks right

C

Chrism

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)&LOOKUP($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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Format of Text 1
How do I format text that is part of a formula? 5
Using the text from a cell as a range name in a formula 3
How do I change the cell format to currency without a formula? 1
How do I retain the format of varying numbers in Excel? 6
text and formula in the same cell - how do I format this cell?? 4
How do I replace my vlookup FORMULA with just the TEXT of results 1
how can i hidden the formula(excel) in cell when i click on it so. 1

Top