| 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? |
| 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 | |||
Threaded Mode
