Any suggestions

  • Thread starter Thread starter Eamon
  • Start date Start date
E

Eamon

Hi,

Any suggestions for the problem as laid out below will be much appreciated.

In column D9:D100 I have...
£
$
€ etc!
and in column E9:E100 I have a unit price i.e.
10.00
25.00
15.00 etc!

How can I include the symbol in column D, in front of the unit price in
column E?

Thanks,

Eamon
 
Hi Eamon,

=A1&B1

or

=A1&TEXT(B1,"0.00")

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
Hi Eamon!

With just a few cases, I'd usually recommend using the currency
formats available.

You can use:

F9: (As an example)
=D9&E9
Copy down

But the result is text. If you want to do any calculations you would
need to use the E9 entry

Example
G9: 7
=D9&(E9*G9)

Since the result isn't a number you won't have number formats
available. But you might achieve a similar result:

=D9&TEXT((E9*G9),"###.00")

But there may well be a VBA approach that will allow selection of
currency format using the D9 symbol.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top