V 11.1 Decimal places: change from format/cells & from toolbarBUT->

  • Thread starter Norman R. Nager, Ph.D.
  • Start date
N

Norman R. Nager, Ph.D.

With Excel 2004, when I go into format/cells/numbers and change decimal
places to 0 or when I reduce the decimal cells for a column or cell from the
toolbar, I end up with "3" being entered as "0.03" unless I either type a
quotation mark before the numeral or add a ".00" after the numeral.

Your counsel, please?

Respectfully, Norm
 
P

Peo Sjoblom

Look under excel>preferences>edit and uncheck fixed decimal places
(tools>options>edit under windows excel)

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 

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

Getting text or numerical data from the formula 2
Formatting for Two Decimal Places 3
eliminating decimal places 3
Limit decimal places without format statement 5
Decimal Place goes crazy when using the "&" Sign. 4
Formatting Decimal Places 3
Variable Defined as Double is entered in cell with only 2 decimal places 2
Formatting decimal places 8

Top