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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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