In Excel, can you use a custom format to get a percent sign added to the number but NOT multiplied by 100?

Question

For example, I want the number 62.49 to display as 62.49%.  

But, I am linking 100s of numbers from another application and it is not a simple task to divide by 100.  Thus, I want to know if I can do it just using the custom formatting options.

This can be Excel 2007 or 2003.

IXL@XL · Accepted Answer

Try custom format 0.00"%"
Hope this is what you require.

? · Answer

as properly to the above whilst typing the extensive form merely form the only quote ' front of the extensive form and attractiveness the extensive form, which will tension excel to handle it as text fabric. '00078T3Q like the above whilst typing upload single quote in front of the extensive form. ------------------------ Ms-Exl-Learner ------------------------

Trending News

In Excel, can you use a custom format to get a percent sign added to the number but NOT multiplied by 100?

2 Answers