Enter 100 in een empty cell.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
Copy it.
Select the values of interest.
Activate Edit|Paste Special >Divide.
Like this thread? Share it with others