Changing format in Text Annotations

C
Craig Adams 👤 Member for 19 years 7 months

Hello Fellow Asta travellers,

Anyone know how to change percentage complete if using overall percent complete in text annotations to show % instead of default two decimal places.

Am pointing to overall percentage which by default has two devcimal places, then changed this and refreshed view - annotation did not change.

 

23-09-2011_11-03-am.jpg

Whilst on this, is there somewhere were we can set default to no decimal places for all??

Thankyou in anticipation!

M
Mike Testro 👤 Member for 20 years 5 months

Hi Craig

I have just replicated your situation and the 2 decimal default is fixed - I could find no way to edit it.

You can put a text % symbol after the decimals.

Put it on the Asta Wish List for the next edition.

Best regards

Mike Testro

C
Craig Adams 👤 Member for 19 years 7 months

Hello Mike,

I understand how to change percent to show % in columns, however in this case I am using annotations in the chart area and I have set them to show the percentages.

The annotations do not change when you change the columns, they remain the same with two decimal places. It's the annotations I am unable to change formating of not the actual percentage column.

Cheers,

Craig Adams

M
Mike Testro 👤 Member for 20 years 5 months

Hi Craig

High Light the coloumn

Right Click and select Format Cells

Select Percent - select 0 decimals

Click OK and you get the percent sign.

Best regards

Mike Testro

Forum Sponsor

Top Posters

Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts