Results 1 to 4 of 4

Number Formats Automatically Change

Threaded View

STBTC Number Formats Automatically... 03-24-2017, 07:45 AM
Pete_UK Re: Number Formats... 03-24-2017, 07:52 AM
STBTC Re: Number Formats... 03-24-2017, 12:08 PM
Pete_UK Re: Number Formats... 03-24-2017, 12:53 PM
  1. #1
    Forum Contributor
    Join Date
    12-22-2015
    Location
    San Antonio, Texas
    MS-Off Ver
    2016
    Posts
    116

    Number Formats Automatically Change

    In the attached workbook I have done nothing: no cell formatting or anything. I think I may have accidentally changed something in Excel to do this; but when I open a new workbook, and type a general number, the format changes to where a decimal is added, or the number changes completely. Exempli gratia, I type 666666; the cell changes it to 666.66; I type 1973; the cell changes to 19.73. Remember: I just opened the workbook and typed numbers. I haven’t formatted a cell, and then typed it. It isn’t reserved to one workbook. It does it to all workbooks of mine. I have Excel 2016 on a Mac.
    Please help me. Thank you.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Why Does Excel Change Cell Formats Automatically?
    By Sandcastle in forum Excel General
    Replies: 3
    Last Post: 12-30-2015, 03:32 PM
  2. Replies: 2
    Last Post: 07-15-2014, 08:24 PM
  3. [SOLVED] PasteSpecial with number formats but without conditional formats or borders
    By bodhi808 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-18-2013, 09:58 AM
  4. [SOLVED] How to Change all the different Number formats to a uniform format.
    By adil.master in forum Excel General
    Replies: 3
    Last Post: 09-14-2012, 06:07 AM
  5. [SOLVED] Excel should allow me to change default number formats
    By kakers in forum Excel General
    Replies: 1
    Last Post: 01-11-2006, 07:45 PM
  6. How to automatically change number of pages to print?
    By Husker87 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-25-2005, 10:35 AM
  7. [SOLVED] how does an invoice number change automatically ?
    By JudyRuiz in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 04-08-2005, 12:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1