Having googled i I was informed just to put the text into double quotes.

=B13-(B7/12) but

="("B13-(B7/12)")"

is there a better way?

I then tried ="(" & B13-(B7/12) & ")" but now I get


(244.728365) instead of £244.73

[QUOTE=Pablo2000;180602="("B13-(B7/12)")"
is there a better way?[/QUOTE]
Yes!

Why not just =B13-(B7/12) and format as currency ?

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Seriously. Keep it the same!

ArviLaanemets sugests
Why not just =B13-(B7/12) and format as currency ? It is already curency and in a currency cell.

and forget about adding text like "(". I want
(£244.73)

Why am I being told off? I am closing this now. Not fair on me.

What does this mean?
Nope, Arvi did not suggest it
This does not appear in any of your posts?
Whatever gave you that impression?

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

I have a cell that gives a calculation of £244.73.
I get
That would sugest this is supposed to be currency and by adding the text it has turned it into a number instead.

Perhaps a custom format instead of currency? (£#.##0,00)
That way the underlying value stays a number
Otherwise =TEXT(B13-(B7/12),"(£#.##0,00)") ( it is then text not a number anymore)

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

No that doesn't work. I will speak english.

Before all of this I had 2 cells. Both of these cells were set as curancy.
B12 = £3,1530.30
Cell B13 = B2/12 which gives a value of £262.78. ALL I WANTED was to have (£262.78)

Never thought this would be difficult. Why would MS convert it to text? It is a calculation starting with '=' calculations are numbers.

In Excel, numbers, currencies, or daters - they all are really numbers. When you format a cell, you don't change the number you have there, you only change how this number is displayed.

So when you enter 262.78 into cell, and left the format of cell General, there will be number 262.78 stored, and it is displayed as 262.78;
When you format the same cell as number with 4 decimals, the number itself remains 262.78, but it will be displayed as 262.7800;
When you format the same cell as number as integer, the number itself remains 262.78, but it will be displayed as 263;
When you format the same number as currency, the number itself again remains 262.78, but it will be displayed accordingly of the currency format set for OS of your computer, i.e. £262.78 for you, or something like $262.78 for US user, or 262,78 € for many of other European countries;
When you celect a custom format for cell, there is possibility to format the same cell to be displayed as (£262.78) too - and again the number remains same;
You even can format the same cell as date - you get some date from year 1900, plus some hours, minutes and seconds in case you set this format to display the time too - and the real value of cell will be 262.78.

When you concatenate (i.e. use formula containing & operator) some number with any string, then the result is always string!

I will speak English too.
Select your destination cell - Right click - Format Cells - Number Tab - Custom - In the "type" field enter (£#.##0,00) ( Bold is unnecessary)
See attached.
The result IS A NUMBER as it is RIGHT ALIGNED in the cell. Text is always LEFT ALIGNED ( provided no manual alignment is applied)
And BTW please be careful when you give an example. In post # 20 you wrote Isn't there n extra zero ?

Attached Files

Custom Format.xlsx (8.9 KB, 0 views)

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post