ExcelBanter - Excell 2003 for Students & Teachers

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Excell 2003 for Students & Teachers (https://www.excelbanter.com/excel-worksheet-functions/17422-excell-2003-students-teachers.html)

Richard

Excell 2003 for Students & Teachers

I insert 85 into a cell. Excell then changes the value to .085.
I think this happened when I tried to cut and paste a formula.
How do I reset to the original program?

JulieD

Hi Richard

try tools / options / edit
and untick fixed decimal places

Cheers
JulieD

"Richard" wrote in message
...
I insert 85 into a cell. Excell then changes the value to .085.
I think this happened when I tried to cut and paste a formula.
How do I reset to the original program?

Bob Phillips

Check that the option ToolsOptionsEdit Fixed decimal is not checked. If it
is, uncheck it.

--

HTH

RP
(remove nothere from the email address if mailing direct)

"Richard" wrote in message
...
I insert 85 into a cell. Excell then changes the value to .085.
I think this happened when I tried to cut and paste a formula.
How do I reset to the original program?

All times are GMT +1. The time now is 05:28 PM.