Why does excel divide numbers I type by 10 after I hit return?
Why does excel divide numbers I type by 10 after I hit return?
Try this: Go to Tools-->Options, Edit tab. Uncheck the Fixed Decimal box.
*******************
~Anne Troy
www.OfficeArticles.com
www.MyExpertsOnline.com
"Djavad" <Djavad@discussions.microsoft.com> wrote in message
news:60479D99-039F-4D11-9C1C-8247BADF8924@microsoft.com...
> Why does excel divide numbers I type by 10 after I hit return?
Thank you, it worked! Pusing my luck: how do I prevent excel from turning
"(x)" into "-x" automatically?
Djavad.
"Anne Troy" wrote:
> Try this: Go to Tools-->Options, Edit tab. Uncheck the Fixed Decimal box.
> *******************
> ~Anne Troy
>
> www.OfficeArticles.com
> www.MyExpertsOnline.com
>
>
> "Djavad" <Djavad@discussions.microsoft.com> wrote in message
> news:60479D99-039F-4D11-9C1C-8247BADF8924@microsoft.com...
> > Why does excel divide numbers I type by 10 after I hit return?
>
>
>
Apply a custom format of General;(General)
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Djavad" <Djavad@discussions.microsoft.com> wrote in message
news:C43C7D12-6F58-4C0F-8B31-AE41AABB07EA@microsoft.com...
> Thank you, it worked! Pusing my luck: how do I prevent excel from
turning
> "(x)" into "-x" automatically?
> Djavad.
>
>
> "Anne Troy" wrote:
>
> > Try this: Go to Tools-->Options, Edit tab. Uncheck the Fixed Decimal
box.
> > *******************
> > ~Anne Troy
> >
> > www.OfficeArticles.com
> > www.MyExpertsOnline.com
> >
> >
> > "Djavad" <Djavad@discussions.microsoft.com> wrote in message
> > news:60479D99-039F-4D11-9C1C-8247BADF8924@microsoft.com...
> > > Why does excel divide numbers I type by 10 after I hit return?
> >
> >
> >
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks