="[ " & 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?