| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem is displaying formula | Excel Discussion (Misc queries) | |||
| Problem displaying color | Excel Discussion (Misc queries) | |||
| i am having problem displaying the custom properties | Excel Discussion (Misc queries) | |||
| Problem displaying recordsets in Excel Format | Excel Discussion (Misc queries) | |||
| Problem in displaying the chart | Charts and Charting in Excel | |||
Linear Mode
