1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Excel formatting problem

Discussion in 'Business Applications' started by Neovoca, Jul 10, 2012.

Thread Status:
Not open for further replies.
Advertisement
  1. Neovoca

    Neovoca Thread Starter

    Joined:
    Jul 10, 2012
    Messages:
    4
    Hi,
    For months I have put up with this! Whenever I enter a number in a cell it converts to a percentage e.g. 10 becomes 0.10
    I've tried everything and am probably missing something simple! Any help appreciated - running office for mac 97-2004
    Thanks:confused:
     
  2. Neovoca

    Neovoca Thread Starter

    Joined:
    Jul 10, 2012
    Messages:
    4
    Hi,
    For months I have put up with this! Whenever I enter a number in a cell it converts to a percentage e.g. 10 becomes 0.10
    I've tried everything and am probably missing something simple! Any help appreciated - running office for mac 97-2004
    Thanks :confused:
     
  3. GeorgeJ

    GeorgeJ

    Joined:
    Jan 16, 2012
    Messages:
    144
    Is this on a particular workbook or all workbooks, even new ones?

    Never used a mac so maybe a little hit or miss with this.
    When you rightclick the cell and format - what is the number formatting?
     
  4. etaf

    etaf Wayne Moderator

    Joined:
    Oct 2, 2003
    Messages:
    55,966
    i have moved to business applications forum

    can you load a spreadsheet with the problem and with dummy data
     
  5. GeorgeJ

    GeorgeJ

    Joined:
    Jan 16, 2012
    Messages:
    144
  6. Neovoca

    Neovoca Thread Starter

    Joined:
    Jul 10, 2012
    Messages:
    4
  7. Neovoca

    Neovoca Thread Starter

    Joined:
    Jul 10, 2012
    Messages:
    4
    just 2 decimal places...all appears normal when I do this
     
  8. GeorgeJ

    GeorgeJ

    Joined:
    Jan 16, 2012
    Messages:
    144
    I get to the neovoca Ltd login page so i'm guessing this file is on your companies domain.

    Isntead of reply, hit go advanced - in the additional options section there is a manage attachments section where you can browse to your file and upload it. Just make sure it does not contain any sensitive or confidential information.
     
  9. etaf

    etaf Wayne Moderator

    Joined:
    Oct 2, 2003
    Messages:
    55,966
    now merged
     
  10. Garf13LD

    Garf13LD

    Joined:
    Apr 17, 2012
    Messages:
    455
    How about using custom number format "0%" (without quotes)
     
  11. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1060388