ExcelBanter - Add decimal point from last 2 digit

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Add decimal point from last 2 digit (https://www.excelbanter.com/excel-programming/368117-add-decimal-point-last-2-digit.html)

[email protected]

Add decimal point from last 2 digit

Does anybody has a macro which would add a decimal point from last 2
digit of a selection of numbers

eg 12345 would change to 123.45
34567 to 345.67

Peter T

Add decimal point from last 2 digit

x = 12345 / 100

seems too obvious !

Regards,
Peter T

wrote in message
ups.com...
Does anybody has a macro which would add a decimal point from last 2
digit of a selection of numbers

eg 12345 would change to 123.45
34567 to 345.67

All times are GMT +1. The time now is 05:08 AM.