my cell entries are automatically being displayed as a decimal?
 

Hi,

For some reason all my numerical entries are being entered as a decimal.
Example: I enter 65 in a cell and it changes to .065

This happens regardless of whether the spreadsheet is new or existing.

Anybody know of a fix?

Regards
Max

my cell entries are automatically being displayed as a decimal?
 

toolsoptionsedit, deselect fixed decimal places


--
Regards,

Peo Sjoblom



"Max" wrote in message
...
Hi,

For some reason all my numerical entries are being entered as a decimal.
Example: I enter 65 in a cell and it changes to .065

This happens regardless of whether the spreadsheet is new or existing.

Anybody know of a fix?

Regards
Max

my cell entries are automatically being displayed as a decimal?
 

Tools/Options/Edit uncheck the Fixed decimal places checkbox.

In article ,
Max wrote:

Hi,

For some reason all my numerical entries are being entered as a decimal.
Example: I enter 65 in a cell and it changes to .065

This happens regardless of whether the spreadsheet is new or existing.

Anybody know of a fix?

Regards
Max

my cell entries are automatically being displayed as a decimal?
 

Click TOOLS/OPTIONS and click the EDIT tab. Verify that the Fixed Decimals
checkbox has not been checked on. This automatically punctuates numeric
entries with the number of stated decimal positions (default of 2).
--
Kevin Backmann


"Max" wrote:

Hi,

For some reason all my numerical entries are being entered as a decimal.
Example: I enter 65 in a cell and it changes to .065

This happens regardless of whether the spreadsheet is new or existing.

Anybody know of a fix?

Regards
Max

my cell entries are automatically being displayed as a decimal?
 

Sounds like the Fixed Decimal places option is selected. To deselect it, go to

Tools Options
Select the Edit tab and uncheck the Fixed Decimal box if it is checked.
--
Elisabeth


"Max" wrote:

Hi,

For some reason all my numerical entries are being entered as a decimal.
Example: I enter 65 in a cell and it changes to .065

This happens regardless of whether the spreadsheet is new or existing.

Anybody know of a fix?

Regards
Max

my cell entries are automatically being displayed as a decimal
 

Thanks to all.
That did the trick... now if I can figure out how I checked the box to begin
with :)

"JE McGimpsey" wrote:

Tools/Options/Edit uncheck the Fixed decimal places checkbox.

In article ,
Max wrote:

Hi,

For some reason all my numerical entries are being entered as a decimal.
Example: I enter 65 in a cell and it changes to .065

This happens regardless of whether the spreadsheet is new or existing.

Anybody know of a fix?

Regards
Max