Help: Formatting Percentages

  • Thread starter Thread starter Jon Sprague
  • Start date Start date
J

Jon Sprague

This is similar to a previously posted message

I need to change a number format, say 18.9 to 18.9%
The data is being exported from a source that does not include raw data
(ie. 189), or %signs with the data.

Any suggestions on how to change or format a selected set of numbers
(say a column) either using a custom code or VBA?

Any help would be appreciated.

Thank You
 
Jon,

If the situation is :
The column contains numbers that are 100* the vaqlue they should have and
you want them diveded by 100 and show as percentages :

1) Put 100 in an empty cell and copy it.
2) Select the column and Edit / Paste special / Divide
3) Format as percentage

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
Back
Top