custom-number-formats.PNG

Profit Sharing Projects

Ted Penner

<div>
Thank you very much. &nbsp;That worked!
</div>


<div>
Glad that worked for your Ted!
</div>


<div>
<div class="content wysiwyg-content">
I have a formula in the sheet below that shows a value but needs to show a percentage.<br />
<br />
Unfortunately, the % icon does not do what I want it to. &nbsp;I simply want the % to be represented to the right side of the number so that the decimal placement is retained.<br />
<br />
<a href="https://docs.google.com/spreadsheets/d/13xoGB01HD6ojaAwyUtOYO0HqGL9lf_osDvF6WcOI4Ds/edit?usp=sharing" rel="ugc">https://docs.google.com/spreadsheets/d/13xoGB01HD6ojaAwyUtOYO0HqGL9lf_osDvF6WcOI4Ds/edit?usp=sharing</a><br />
<br />
The current formula in cell N3 is below and assistance is greatly appreciated.<br />
<br />

<pre><code id="code-10-29139002-1">=((L3-L2)/L2)*100</code></pre>
</div>
</div>


I have a formula in the sheet below that shows a value but needs to show a percentage.

Unfortunately, the % icon does not do what I want it to.  I simply want the % to be represented to the right side of the number so that the decimal placement is retained.

https://docs.google.com/spreadsheets/d/13xoGB01HD6ojaAwyUtOYO0HqGL9lf_osDvF6WcOI4Ds/edit?usp=sharing

The current formula in cell N3 is below and assistance is greatly appreciated.

(CODE)

Show percent increase or decrease

A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.