Excel: How can I get numbers without decimals ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
Tools>Options>Edit, uncheck Fixed decimal

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
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...

-- (e-mail address removed)
 
Back
Top