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?
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?
Hi Richard
try tools / options / edit
and untick fixed decimal places
Cheers
JulieD
"Richard" <[email protected]> wrote in message
news:[email protected]...
>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?
Check that the option Tools>Options>Edit Fixed decimal is not checked. If it
is, uncheck it.
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Richard" <[email protected]> wrote in message
news:[email protected]...
> 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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks