two decimals - remove percentage sign - custom format

A

ainbinder

Hello everyone,

I have percentages that i'm displaying in graphs with data labels. I'd
like to remove the % sign so it is easier to view the data labels
because the graphs are small, and i'd like to do it with custom
formatting because there is quite a lot of data that i dont want to
convert to whole numbers.

I think the best way to do this is to somehow use custom formatting in
format cells -->number-->custom to multiply by 100 and display it that
way. is that possible?

Thanks for the help!
Adam
 
Top