Home |
Search |
Today's Posts |
#1
|
|||
|
|||
format_text values
I have a the following value in a cell: [ 123.45]
I need to add 10% to the value and preserve the formatting. I've split the value(123.45) into another cell(M3) Thus, the formula would be : ="[" & TEXT(M3*1.1,"0.00") & "]" which results in [135.80]. The answer should have looked like [ 135.80] What should the format_text value have been? |
#2
|
|||
|
|||
="[ " & TEXT(M3*1.1,"0.00") & "]"
Mangesh "Johan" wrote in message ... I have a the following value in a cell: [ 123.45] I need to add 10% to the value and preserve the formatting. I've split the value(123.45) into another cell(M3) Thus, the formula would be : ="[" & TEXT(M3*1.1,"0.00") & "]" which results in [135.80]. The answer should have looked like [ 135.80] What should the format_text value have been? |
#3
|
|||
|
|||
or even
="[" & TEXT(M3*1.1," 0.00") & "]" -- HTH RP (remove nothere from the email address if mailing direct) "Mangesh Yadav" wrote in message ... ="[ " & TEXT(M3*1.1,"0.00") & "]" Mangesh "Johan" wrote in message ... I have a the following value in a cell: [ 123.45] I need to add 10% to the value and preserve the formatting. I've split the value(123.45) into another cell(M3) Thus, the formula would be : ="[" & TEXT(M3*1.1,"0.00") & "]" which results in [135.80]. The answer should have looked like [ 135.80] What should the format_text value have been? |
#4
|
|||
|
|||
I found the answer :-)
Problem with the other 2 solutiuons were (sorry guys a bit vague in my question) that if the amount was 1234.56, it should show as [1234.56] in stead of [ 1234.56]. The answer is : ="[" & TEXT(M3*1.1,"___0.00") & "]" "Johan" wrote: I have a the following value in a cell: [ 123.45] I need to add 10% to the value and preserve the formatting. I've split the value(123.45) into another cell(M3) Thus, the formula would be : ="[" & TEXT(M3*1.1,"0.00") & "]" which results in [135.80]. The answer should have looked like [ 135.80] What should the format_text value have been? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Match function with duplicate values in an array | Excel Worksheet Functions | |||
Min values in a list of numbers | Excel Worksheet Functions | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
Combine FREQUENCY and SUM of Associated Values | Excel Worksheet Functions | |||
Second serie doesn't use X-as values | Charts and Charting in Excel |