FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT.

S

SUKYKITTY

I have set options to fixed decimal 2 places. But when I enter numbers, i
have to enter all zeros after decimal point. Entering the period does not
work. For example,
100.00 must be entered as 10000. If i enter 100. it inputs 1.00. Excel is
not accepting a period as a decimal place. Does anyone know what needs to be
set for this problem? Thanks
 
C

Carlos Antenna

Rather than setting fixed decimal places in Tools|Options, format the cells:
Format|Cells|Number|2 decimal places.

-- Carlos
 
J

Jerry W. Lewis

What is your Excel version and regional settings (Start|Settings|Control
Panel|Regional Settings)? In Excel XP with Country/Region set to United
States Excel does respect the period as the decimal place on input
despite the fixed decimal setting.

Jerry
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

fixed decimal formatting 2
tiny discrepancies in fixed-point numbers 3
Fixed decimal places in Excel 4
Convert 10 Decimal Places to 2 3
Fixed Decimals in Excel 2007 4
How to set "fixed decimal" in 2007 4
Automaticallychanging the number of decimal places displayed 5
Decimal Places 1

Top