Excel: How can I get numbers without decimals ?

W

Wamalapada

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.
 
N

Niek Otten

Tools>Options>Edit, uncheck Fixed decimal

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
C

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.
Click to expand...

-- [email protected]
 
Top