Number formatting query

[JackDanIce]

Hi,

I have a table of values, some to 2.dp, some 1.dp and some whole numbers only.

How can I format this table to show only show the number of dp that the number is? E.g.

Current table values:

1.25
2.50
3.75
5.00

Desired look:

1.25
2.5
3.75
5

I don't want a macro or event trigger solution; is there a way to force the cell formatting to adjust for this?

Thank you in advance,
Jack

 

[JamesW]

Try formatting them to General.

 

[Andrew Poulsom]

Try the format

0.??

although integers will be followed by a decimal point.

 

[JackDanIce]

James - General almost works, but I have negative numbers shown as red and general stops this showing.

Andrew - yes, it shows the decimal point with your suggestion when I don't want that to happen for whole numbers.

Thank you both, I think I'll have to retain it showing 2dp across all numbers - always a trade off!

Best,
Jack

 

[HRIS]

Try custom: General;[Red]General

 

[Andrew Poulsom]

If you want negatives in red with the General format use:

General;[Red]-General

Personally, I think decimals should be aligned because it makes it easier to add up the numbers. But I'm an accountant so others may disagree.

 

[JackDanIce]

Perfect, thanks HRIS and Andrew,

Andrew understand exactly what you mean, but this is for a accrual issue we have over free-days that is credited back to us for work we do.. and I got formuale to do the adding up for me! It's just about layout and presentation and ease of readibility.

Much appreciated, thanks again,
Jack