Results 1 to 3 of 3

Excel 2010 with same format in all cell

Threaded View

Ivar_ Excel 2010 with same format... 10-30-2015, 06:46 AM
Pete_UK Re: Excel 2010 with same... 10-30-2015, 07:58 AM
Ivar_ Re: Excel 2010 with same... 10-31-2015, 05:28 AM
  1. #1
    Registered User
    Join Date
    10-30-2015
    Location
    Sweden
    MS-Off Ver
    Excel 2010 Pro
    Posts
    2

    Excel 2010 with same format in all cell

    Hi!
    Excel 2010 suddenly got the same format in all cells.
    If I open an old or new sheets so are one and the same format to all cells and I mean really in all cells.
    For example, I enter 457889 into a cell, the answer 4578.89, I write 456 the answer is 4.56 then the cell content controlled to be mandatory two decimal places at the end.
    If I open an earlier document, before this happened, so everything looks right out and all numbers etc are correct, but if I try to add new values to an old document that will be the format as above with the obligatory 2 decimal places and as you can understand the result disaster.
    To change the cell formats can not get the same results no matter how I do.
    I can not find where this oddity comes from or how I should get rid of this, as you understand it's completely stopped my work.
    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. How to paste special in Outlook 2010 from a copied cell in Excel 2010
    By Baldowsky in forum Outlook Formatting & Functions
    Replies: 0
    Last Post: 05-30-2014, 11:40 AM
  2. Excel 2010 or Excel 2003 : Conditional format for consecutive cell criteria
    By carol_sarah_759 in forum Excel - New Users/Basics
    Replies: 7
    Last Post: 12-04-2013, 09:04 PM
  3. Excel 2010 fromats every cell in every sheet to date format
    By captbluefin in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-11-2013, 11:53 AM
  4. Replies: 8
    Last Post: 11-09-2012, 07:28 AM
  5. [SOLVED] Change conditional format (color) of a cell based on another celll (Excel 2010)
    By ffnptown in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-28-2012, 09:50 PM
  6. Replies: 5
    Last Post: 03-29-2012, 10:02 AM
  7. DDE Excel 2010 Format with Mail Merge in Word 2010
    By usc1382 in forum Excel General
    Replies: 0
    Last Post: 01-18-2011, 01:21 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