Decimals

RG0071580

I assume that for 12,34 [sic], comma is the decimal point in your region.  That is, it represents 12 + 34/100.

And I believe that you want to enter the numbers without an explicit decimal point, and you ask that Excel inserts the decimal point to the left of the last two digits automagically.

There is an option for that.  But how to find and selecxt it varies depending on platform (PC vs Mac) and Excel version.

In my version, I click File > Options > Advanced, then checkmark the option Automatically Insert Decimal Point.

Of course, cells might also need to be formatted to display 2 decimal places.

RG0071580 

The difference between the numbers as you show them is a factor of 100.  Do you actually wish to change the number or merely its presentation?

If the former, then use the formula

= number / 100

If the result has to be in the original position on the sheet, then copy and paste/values over the source data.

If you wish to change the presentation but leave the values unaltered then the decimal separator can be 'faked' by using an appropriate number format

0\,00

Hi RG0071580 

What do you mean by decimals, it usually refers to the number in fractions like the cents in dollors.

if so, select the column then just click on increase Decimal from the number groups, in the home tab; usually the decimal sign  is the DOT . but you can change it from File table --> options --> Advanced tab --> change the Decimal Operator to ,