Custom format for decimal places

[FryGirl]

Is there a custom format that can be applied to the following? Results like in column B, but I'm needing to apply the custom format on column A. Column A is the result of a formula.

[Table="class: grid"][tr][td] [/td][td]

A​

[/td][td]

B​

[/td][/tr]
[tr][td]

1​

[/td][td]

15.28​

[/td][td]

15.28​

[/td][/tr]

[tr][td]

2​

[/td][td]

15.00​

[/td][td]

15​

[/td][/tr]

[tr][td]

3​

[/td][td]

12.23​

[/td][td]

12.23​

[/td][/tr]

[tr][td]

4​

[/td][td]

0.02​

[/td][td]

0.02​

[/td][/tr]

[tr][td]

5​

[/td][td]

14.00​

[/td][td]

14​

[/td][/tr]

[tr][td]

6​

[/td][td]

0.11​

[/td][td]

0.11​

[/td][/tr]
[/table]

 

[Joe4]

If you choose the General Format (in which you do NOT denote the number or decimal places), it should do what you want, as long as your calculations in column A do not really have more than 2 decimal places. If they do, just use the ROUND function on your formula in column A, i.e.
=ROUND(your formula, 2)

 

[FryGirl]

Hi Joe,

What if some of those numbers are percent's?

 

[Joe4]

What if some of those numbers are percent's?

You didn't mention that possibility.
In those cases, what do those values look like, and what do you want them to look like?

Note that percents are really just numbers (unless they are entered as text). It is formatting that shows them as percents.
So, the question is, how do you differentiate between them and other numbers?

I think it would be helpful to see exactly what the formulas in column A look like.

 

[FryGirl]

Sorry about that

Data Range
[Table="class: grid"][tr][td] [/td][td]

A​

[/td][td]

B​

[/td][/tr]
[tr][td]

1​

[/td][td]

15.28​

[/td][td]

15.28​

[/td][/tr]

[tr][td]

2​

[/td][td]

15.00​

[/td][td]

15​

[/td][/tr]

[tr][td]

3​

[/td][td]

12.23​

[/td][td]

12.23​

[/td][/tr]

[tr][td]

4​

[/td][td]

0.02​

[/td][td]

0.02​

[/td][/tr]

[tr][td]

5​

[/td][td]

14.00​

[/td][td]

14​

[/td][/tr]

[tr][td]

6​

[/td][td]

0.11​

[/td][td]

0.11​

[/td][/tr]

[tr][td]

7​

[/td][td]

15.00%​

[/td][td]

15%​

[/td][/tr]

[tr][td]

8​

[/td][td]

3.45%​

[/td][td]

3.45%​

[/td][/tr]

[tr][td]

9​

[/td][td]

0.02%​

[/td][td]

0.02%​

[/td][/tr]

[tr][td]

10​

[/td][td]

23.00%​

[/td][td]

23%​

[/td][/tr]
[/table]

 

[Joe4]

What exactly do your formulas in column A show for the percent calculations and non-percent calculations?

 

[FryGirl]

Hi Joe and thanks for your time.

I seperated the two columns and will just use a custom format like [>=1]0;[>0.001]0.00

That's seems to do the job.