Bug - Decimals in Excel Worksheet

I

Ian

On one particular machine, in Excel, any number typed into a worksheet is
automatically converted to a decimal (ie 10 changes to 0.1, 20 changes to
0.2). Have checked all formatting options and they are all OK, have tried
deleting the blank template, and still the problem re-appears.

Has anyone come across this before, could it be a small virus, or just
another bug in the system.

Any help is really appriciated.
 
R

RagDyeR

<Tools> <Options> <Edit> tab,
And *Uncheck*
"Fixed Decimal Places".
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

On one particular machine, in Excel, any number typed into a worksheet is
automatically converted to a decimal (ie 10 changes to 0.1, 20 changes to
0.2). Have checked all formatting options and they are all OK, have tried
deleting the blank template, and still the problem re-appears.

Has anyone come across this before, could it be a small virus, or just
another bug in the system.

Any help is really appriciated.
 

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

Bug - Decimals in Excel Worksheets 1
Fixed Decimals in Excel 2007 4
Auto deletion of cell entry in given circumstance 0
format issues with decimal places 1
Excel 2007 Import Text file - a bug with the decimal sign "." and 1
Hide/Unhide worksheets upon entries in a range of the main worksheet 5
Numaric to Inword in excel by VB 1
Editing an "IF" function across a worksheet/excel file 2

Top