Problem in displaying number
 

Having problem in displaying number!

A1=25.25 (outcome of some calculations, formatted as
number with two decimal places)

In A10, I am trying to display

Please pay a sum of Rs. 25.25 only

I am using the formula A10="Please pay a sum of Rs. "&A1&" only"

Problem is coming with amounts like 25.00 or 25.50, the cell displays
for 25.50 ---- Please pay a sum of Rs. 25.5 only (what I want is 25.50)
for 25.00----- Please pay a sum of Rs. 25 only (what I want is 25.00)

separating Integar and Fraction part is not of help. Using =right(a1,1) also
does not work.

Help will be appreciated, preferably with use of functions only!

Problem in displaying number
 

Try it like this...

="Please pay a sum of Rs. "&TEXT(A1,"0.00")&" only"

--
Biff
Microsoft Excel MVP


"hsg" wrote in message
...
Having problem in displaying number!

A1=25.25 (outcome of some calculations, formatted as
number with two decimal places)

In A10, I am trying to display

Please pay a sum of Rs. 25.25 only

I am using the formula A10="Please pay a sum of Rs. "&A1&" only"

Problem is coming with amounts like 25.00 or 25.50, the cell displays
for 25.50 ---- Please pay a sum of Rs. 25.5 only (what I want is
25.50)
for 25.00----- Please pay a sum of Rs. 25 only (what I want is
25.00)

separating Integar and Fraction part is not of help. Using =right(a1,1)
also
does not work.

Help will be appreciated, preferably with use of functions only!

Problem in displaying number
 

On Wed, 24 Feb 2010 10:01:01 -0800, hsg wrote:

Having problem in displaying number!

A1=25.25 (outcome of some calculations, formatted as
number with two decimal places)

In A10, I am trying to display

Please pay a sum of Rs. 25.25 only

I am using the formula A10="Please pay a sum of Rs. "&A1&" only"

Problem is coming with amounts like 25.00 or 25.50, the cell displays
for 25.50 ---- Please pay a sum of Rs. 25.5 only (what I want is 25.50)
for 25.00----- Please pay a sum of Rs. 25 only (what I want is 25.00)

separating Integar and Fraction part is not of help. Using =right(a1,1) also
does not work.

Help will be appreciated, preferably with use of functions only!

You need to use the TEXT function to properly format the value within the
string. e.g.

="Please pay a sum of "&TEXT(A1,"""Rs. ""#0.00") & " only"

--ron

Problem in displaying number
 

="Please pay a sum of Rs. "& TEXT(A1,"0.00") &" only"

--
Gary''s Student - gsnu201001


"hsg" wrote:

Having problem in displaying number!

A1=25.25 (outcome of some calculations, formatted as
number with two decimal places)

In A10, I am trying to display

Please pay a sum of Rs. 25.25 only

I am using the formula A10="Please pay a sum of Rs. "&A1&" only"

Problem is coming with amounts like 25.00 or 25.50, the cell displays
for 25.50 ---- Please pay a sum of Rs. 25.5 only (what I want is 25.50)
for 25.00----- Please pay a sum of Rs. 25 only (what I want is 25.00)

separating Integar and Fraction part is not of help. Using =right(a1,1) also
does not work.

Help will be appreciated, preferably with use of functions only!

Problem in displaying number
 

It works!
So simple, but looked so difficult,

Thanks a lot!


"Gary''s Student" wrote:

="Please pay a sum of Rs. "& TEXT(A1,"0.00") &" only"

--
Gary''s Student - gsnu201001


"hsg" wrote:

Having problem in displaying number!

A1=25.25 (outcome of some calculations, formatted as
number with two decimal places)

In A10, I am trying to display

Please pay a sum of Rs. 25.25 only

I am using the formula A10="Please pay a sum of Rs. "&A1&" only"

Problem is coming with amounts like 25.00 or 25.50, the cell displays
for 25.50 ---- Please pay a sum of Rs. 25.5 only (what I want is 25.50)
for 25.00----- Please pay a sum of Rs. 25 only (what I want is 25.00)

separating Integar and Fraction part is not of help. Using =right(a1,1) also
does not work.

Help will be appreciated, preferably with use of functions only!