ExcelBanter - Formula for ecimal place

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

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

- - Formula for ecimal place (https://www.excelbanter.com/excel-discussion-misc-queries/181495-formula-ecimal-place.html)

AngeloG

Formula for ecimal place

If there is a number, say 123456, in cell A1, is there a formula I can write
that will put a decimal point between the 4 and the 5, making the number
1234.56?

Gary''s Student

Formula for ecimal place

=A1/100
--
Gary''s Student - gsnu200775

dennis

Formula for ecimal place

=A1/100

"AngeloG" wrote:

If there is a number, say 123456, in cell A1, is there a formula I can write
that will put a decimal point between the 4 and the 5, making the number
1234.56?

AngeloG

Formula for ecimal place

Makes sense...thanks!

"Gary''s Student" wrote:

=A1/100
--
Gary''s Student - gsnu200775

All times are GMT +1. The time now is 11:13 PM.