Multiply cells and format to currency in text format

P

Paul Wilson

Hi,

I have 2 cells which I wish to multiply, and have the result be formatted in
text with the 2 decimal places.

3 x 1.55 = 4.65
2 x 4 = 8.00

This is going to be used with a program which requires it to be numbers
stored as text. Just basic cell formatting doesn't work.

Can some one please help?

Cheers
 
R

Ron Rosenfeld

Hi,

I have 2 cells which I wish to multiply, and have the result be formatted in
text with the 2 decimal places.

3 x 1.55 = 4.65
2 x 4 = 8.00

This is going to be used with a program which requires it to be numbers
stored as text. Just basic cell formatting doesn't work.

Can some one please help?

Cheers


=TEXT(3*1.55,"$#,##0.00")
--ron
 
J

Jacob Skaria

If you are looking for a VBA solution try

Msgbox Format(Range("A1")*Range("B1"),"0.00")
 

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

Top