Decimals in Excel

I have one column in Excel that I want a fixed decimal, when I select the column and
format it to have decimals it adds two zeros after the decimal. Example I want to enter 5565 and the decimal point would be 55.65, I'm getting 5565.00,how do I get rid of these zeros? I only want this one column to have the decimal. Your help is appreciated.

Thanks,
PJ

[Aladin Akyurek]

On 2002-03-07 10:55, Anonymous wrote:
I have one column in Excel that I want a fixed decimal, when I select the column and
format it to have decimals it adds two zeros after the decimal. Example I want to enter 5565 and the decimal point would be 55.65, I'm getting 5565.00,how do I get rid of these zeros? I only want this one column to have the decimal. Your help is appreciated.

Thanks,
PJ

Enter 100 in een empty cell.

Copy it.

Select the values of interest.

Activate Edit|Paste Special >Divide.

[gplhl]

If you always put in four digits

=MID(E1,1,2)&"."&MID(E1,3,2)

[Tim Francis-Wright]

There is another option that might be useful.

You can have any particular worksheet have as its default a particular number of
decimals: Tools/Options/Edit/Fixed Decimal = 2 (or whatever you want).

This applies to the sheet as a whole. If you want to override it for any particular
cell, include the decimal in the cell entry
(i.e., 6442. yields 6442 but 6442 yields
64.42 if you have 2 decimal places selected.)