my numeric keyboard is always in currency (100enter=1.00)

DB · Apr 28, 2008

I enter 100 in my keyboard, and I have 1.00 in my Excel cell ???
I test with an other keyboard also.

David Biddulph · Apr 28, 2008

Tools/ Options/ Edit:
- uncheck Fixed Decimal Places

Jim Thomlinson · Apr 28, 2008

Tools -> Options -> Edit Tab | uncheck Fixed Decimal Places