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


---
Message posted from http://www.ExcelForum.com/

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 *

"Jon Sprague " wrote in message
...
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


---
Message posted from http://www.ExcelForum.com/