#1
|
|||
|
|||
add text to a calculation
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 |
#2
|
|||
|
|||
[QUOTE=Pablo2000;180602="("B13-(B7/12)")"
is there a better way?[/QUOTE] Yes! Code:
="(" & B13-(B7/12) & ")" |
#3
|
||||
|
||||
Quote:
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 |
#4
|
|||
|
|||
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. |
#5
|
||||
|
||||
Quote:
Quote:
Quote:
Quote:
__________________
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 |
#6
|
|||
|
|||
I have a cell that gives a calculation of £244.73.
I get Quote:
|
#7
|
||||
|
||||
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 |
#8
|
|||
|
|||
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. |
#9
|
|||
|
|||
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! |
#10
|
||||
|
||||
Quote:
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 Quote:
__________________
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 |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Legacy Text Field with Calculation is Rounding | Krhamm | Word Tables | 8 | 12-19-2023 12:47 PM |
Age Calculation | lawlaw | Word | 8 | 06-07-2019 06:22 AM |
Calculation to Pre poutlate Text | gdavey | Word VBA | 4 | 08-19-2015 08:54 PM |
Help with a sum calculation please. | ballst | Excel | 4 | 06-04-2015 11:40 AM |
Please help with age calculation!!! | Microsoft Idiot | Word | 4 | 10-29-2012 05:54 AM |