Excel: How can I get numbers without decimals ?

[Guest]

After entering numbers in a cell they appear as decimals. I have tried going
into Format and changing it to 0 decimal but then I get 0.

Can you please help me.

 

[Niek Otten]

Tools>Options>Edit, uncheck Fixed decimal

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[CyberTaz]

Hi -
It sounds like you have a default # of decimal places set in Options.

Go to Tools>Options & on the Edit page remove the check for Fixed Decimal
Places.

HTH |:>)


On 4/8/05 2:39 PM, in article

After entering numbers in a cell they appear as decimals. I have tried going
into Format and changing it to 0 decimal but then I get 0.

Can you please help me.

-- (e-mail address removed)