ExcelBanter - Converting numbers

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Converting numbers (https://www.excelbanter.com/excel-discussion-misc-queries/101015-converting-numbers.html)

cudan

Converting numbers

I need to convert a column of numbers that are formatted as General and
listed as a percent. (ex. 17.75). How could i convert that number to .1775

Bernard Liengme

Converting numbers

Enter the value 100 in an empty cell and copy it
Select the range of numbers and use Edit |Paste Special Divide
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"cudan" wrote in message
...
I need to convert a column of numbers that are formatted as General and
listed as a percent. (ex. 17.75). How could i convert that number to
.1775

All times are GMT +1. The time now is 08:29 PM.