Feb 05 2017
11:31 AM
- last edited on
Jul 25 2018
09:25 AM
by
TechCommunityAP
Feb 05 2017
11:31 AM
- last edited on
Jul 25 2018
09:25 AM
by
TechCommunityAP
Feb 06 2017 12:23 AM
SolutionHaytham, format the SUM as well, like ="Total: " & TEXT(SUM(D3:D12),"#,##0_ ;-#,##0 "). If I understood your question correctly...
Feb 06 2017 10:58 AM
Thank you Mr. Baklan, this is exactly what I want
But I have noticed another code gives the same result.
The code is: #,##0
What's the difference between it and the code you mentioned?
Feb 06 2017 01:35 PM
Actually no difference, for me it was faster enter the formula ans copy/paste it here. In general, for whole numbers you may use something like TEXT(A1,"#,#"). Another story if you would like to make different formatting for positive and negative numbers, add text and or colors into formatting, etc - all that additional symbols matter.
In particular, you may format your cell with =SUM(D3:D12) as "Total: "#,### (enter this into the Custom format of the cell) that gives the same result.
Comma just separates your number on thousans, millions, billions, etc.
More about formatting is here
https://support.office.com/en-us/article/Number-format-codes-5026bbd6-04bc-48cd-bf33-80f18b4eae68
and i guess in many other places
Sep 06 2018 01:14 AM - edited Sep 06 2018 01:19 AM
If i want to use decimal places in the number, Formula?
Sep 06 2018 01:20 AM
May 14 2019 09:49 PM
I am trying to write a formula where I am using a cell and a rule. Below explains what i am trying to achieve
A1 - $1,000
=A1 &IF(A1<0,"CR",""
The result i get from this is 1000CR. I cannot get it to format to $1,000CR if cell A1 is less than 0. PLEASE HELP
May 15 2019 12:26 AM
@Heelllo , you may apply custom number format to your cell like
[$$-en-US]#,##0;-[$$-en-US]#,##0"CR";[$$-en-US]#,##0
or, if with formula, use
TEXT(A1,"[$$-en-US]#,##0") & "CR"
with IF
Nov 03 2019 09:40 PM
@Haytham Amairah please help me fix this formula
=("5% VAT ON AED")&ROUND(SUM(H36:H37),2) ( the output in the sum i need to add Coma like in accounting format)
Nov 03 2019 09:41 PM
please help me fix this formula
=("5% VAT ON AED")&ROUND(SUM(H36:H37),2) ( the output in the sum i need to add Coma like in accounting format)
Please help me with this
Nov 04 2019 06:21 AM
As variant you may apply desired accounting format to the cell, Ctrl+1, select Custom and add your text in front of each formatting block
Alternatively wrap ROUND with TEXT function applying accounting format string for your locale.
Aug 10 2020 06:18 AM
=LARGE(N6:N15,1)&" on first "&LARGE(N6:N15,2)&" on second "&LARGE(N6:N15,3)&" on third "
Hi can we add separator commas in this formulae.?
THanks
Feb 06 2017 12:23 AM
SolutionHaytham, format the SUM as well, like ="Total: " & TEXT(SUM(D3:D12),"#,##0_ ;-#,##0 "). If I understood your question correctly...