Moving Decimal Point

  • Thread starter Thread starter Alastair
  • Start date Start date
A

Alastair

When entering numbers into cells the decimal point is
being automatically moved two places to the left. For
example "54" comes out as "0.54", however "54.0" or "=54"
comes out as "54". The cells are not formatted as
percentage, I have tried various formats but it seems to
make no difference.
 
Alastair,

You have the Fixed Decimal setting turned on (you'll notice that
down in the lower-right corner of the Excel screen the "FIX"
indicator is visible). Go to the Tools menu, choose Options, then
the Edit tab. There, uncheck the "Fixed Decimal" setting.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
 
Back
Top