Discussion Formulas ($ and % signs, Decimals, Cell references) in Excel
https://techcommunity.microsoft.com/t5/excel/formulas-and-signs-decimals-cell-references/m-p/2682981#M111456
<P>[B]Just a few basic issues when I use formulas in Excel:[/B]</P><P> </P><P>1. A $ sign sometimes appears in the cell even though the cells in the formula do not have $ signs.</P><P> </P><P>2. How can you add a % sign?</P><P> </P><P>3. How can you get rid of decimals?</P><P> </P><P>[U]Obviously you cannot just add or delete the above as cell results are automatic with formulas.[/U]</P><P> </P><P><BR />4. I am mostly using relative cell references (as you probably know, formulas adjust as they are copied), but want to copy a group of formulas and not have them adjust (absolute cell references). I looked this up and it said to select the reference you want to change in the formula bar and press F4, but I could not see where you select the reference. How do you do this or is there another way to do it?</P>Wed, 25 Aug 2021 11:18:52 GMTpeterholt1102021-08-25T11:18:52ZFormulas ($ and % signs, Decimals, Cell references)
https://techcommunity.microsoft.com/t5/excel/formulas-and-signs-decimals-cell-references/m-p/2682981#M111456
<P>[B]Just a few basic issues when I use formulas in Excel:[/B]</P><P> </P><P>1. A $ sign sometimes appears in the cell even though the cells in the formula do not have $ signs.</P><P> </P><P>2. How can you add a % sign?</P><P> </P><P>3. How can you get rid of decimals?</P><P> </P><P>[U]Obviously you cannot just add or delete the above as cell results are automatic with formulas.[/U]</P><P> </P><P><BR />4. I am mostly using relative cell references (as you probably know, formulas adjust as they are copied), but want to copy a group of formulas and not have them adjust (absolute cell references). I looked this up and it said to select the reference you want to change in the formula bar and press F4, but I could not see where you select the reference. How do you do this or is there another way to do it?</P>Wed, 25 Aug 2021 11:18:52 GMThttps://techcommunity.microsoft.com/t5/excel/formulas-and-signs-decimals-cell-references/m-p/2682981#M111456peterholt1102021-08-25T11:18:52ZRe: Formulas ($ and % signs, Decimals, Cell references)
https://techcommunity.microsoft.com/t5/excel/formulas-and-signs-decimals-cell-references/m-p/2683034#M111459
<P><LI-USER uid="1137133"></LI-USER> </P><P> </P><P><STRONG>1,2,3:</STRONG> There are two ways to easily adjust number formats. The first is on the "Home" tool bar, the section that looks like this (except a lot smaller), toward the center of the screen. The icons are pretty self-explanatory, and by clicking on the box showing "General" you get a more extensive set of choices. Change the number of decimal places by those two marked with an arrow in the image below.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="mathetes_0-1629890764573.png" style="width: 400px;"><img src="https://techcommunity.microsoft.com/t5/image/serverpage/image-id/305617iC6EED1B9EFE98163/image-size/medium?v=v2&px=400" role="button" title="mathetes_0-1629890764573.png" alt="mathetes_0-1629890764573.png" /></span></P><P>The other place you can accomplish the same is in the main menu up at the top of your screen, Format...Cells...</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="mathetes_2-1629891002931.png" style="width: 400px;"><img src="https://techcommunity.microsoft.com/t5/image/serverpage/image-id/305620iD826B4C7B30B944D/image-size/medium?v=v2&px=400" role="button" title="mathetes_2-1629891002931.png" alt="mathetes_2-1629891002931.png" /></span></P><P>which takes you to this dialog box</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="mathetes_1-1629890943448.png" style="width: 400px;"><img src="https://techcommunity.microsoft.com/t5/image/serverpage/image-id/305618i6FAEF13A52F081DA/image-size/medium?v=v2&px=400" role="button" title="mathetes_1-1629890943448.png" alt="mathetes_1-1629890943448.png" /></span></P><P> </P><P>4. You select a reference in a formula by just placing your cursor on it. Then pressing F4 will cycle through the options, the different degrees of absolute:</P><UL><LI>Absolute in row and column <STRONG>$A$1</STRONG></LI><LI>Absolute in row but relative in column <STRONG>A$1</STRONG></LI><LI>Absolute in column but relative in row <STRONG>$A1</STRONG></LI><LI>and fully relative <STRONG>A1</STRONG></LI></UL><P> </P>Wed, 25 Aug 2021 11:34:00 GMThttps://techcommunity.microsoft.com/t5/excel/formulas-and-signs-decimals-cell-references/m-p/2683034#M111459mathetes2021-08-25T11:34:00Z