Jump to content

Welcome to Geeks to Go - Register now for FREE

Need help with your computer or device? Want to learn new tech skills? You're in the right place!
Geeks to Go is a friendly community of tech experts who can solve any problem you have. Just create a free account and post your question. Our volunteers will reply quickly and guide you through the steps. Don't let tech troubles stop you. Join Geeks to Go now and get the support you need!

How it Works Create Account
Photo

Decimal Points


  • Please log in to reply

#1
fothers

fothers

    Member

  • Member
  • PipPip
  • 24 posts
Hi

Crazy question, which everyone in the world will know the answer too except me. :)

In excel when I type a number excel converts it by moving the decimal point to the left to places.
For example I input 56378 and hit enter and excel changes it to 563.78. It just started yesterday and i can't think of a reason for it.
I use Grove 2007 with my partner for when we are working on quotes together, could it have something to do with this ?
We both are using office 2007.

Hope someone can answer my silly question...
regards
Ian :)
  • 0

Advertisements


#2
Vino Rosso

Vino Rosso

    Visiting Staff

  • Visiting Consultant
  • 235 posts
Try Tools > Options > Edit Tab

Untick 'Fixed Decimal Places' option

OK
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP