ExcelBanter - Decimal Question

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Decimal Question (https://www.excelbanter.com/excel-worksheet-functions/28317-decimal-question.html)

Scooterdog

Decimal Question

Let's say you type in the whole number 37 in cell A1.
In Cell A2, I would like excel to convert the whole number
to .37 (decimal 37)!
How can I do this?
Thank you in advance

Peo Sjoblom

=A2/100

--
Regards,

Peo Sjoblom

"Scooterdog" wrote in message
...
Let's say you type in the whole number 37 in cell A1.
In Cell A2, I would like excel to convert the whole number
to .37 (decimal 37)!
How can I do this?
Thank you in advance

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