Custom Cell Formatting

A

Alex

I have percentages of a total that I don't want to display
with the percent sign, but I want them to be in that
annotation.

For example:
Current Cell
.055321
Percentage Format
5.5%
Objective
5.5

How can I use custom cell formatting or programming to
multiple given numbers by 100?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
How to make a VBA Function return a value in percent format 8
Weighted % Complete calculation 1
Merging from an Excel file with graphics 1
Printing Outline view - formatting lost 0
macro alternate conditional format change 0
ASK Field Formatting 1
Word macro that can call cells out of Excel for a find and replace 0

Top