+ Reply to Thread
Results 1 to 3 of 3

Excel 2013. All sheets being automatically changed to Currency format

  1. #1
    Registered User
    Join Date
    12-02-2013
    Location
    Shanghai, China
    MS-Off Ver
    Excel 2013
    Posts
    1

    Question Excel 2013. All sheets being automatically changed to Currency format

    We have 3 PCs, all running MS Office 2013. On 1 of these machines, it is doing strange things with formatting. If you open a document or try to paste anything into certain documents, it decides everything is currency format and assigns all sorts of wrong formatting to the entire sheet, or the entire document. There may be some cells in the doc that are indeed currency, but only a small proprtion. If I open a new, fresh document and paste into that document, it does not do this, it seems to work normally, only applying currency formatting where it might be applicable. On some larger docs that have this issue, no matter what I do, it just continues to apply these strange settings. I am not a computer or Excel expert, but not completely inept either. It is driving me to despair, I've tried Googling, but can't find any sort of setting that could help to explain this strange behaviour. Any suggestions welcome.

    Thanks
    Lynchy

  2. #2
    Forum Contributor
    Join Date
    10-30-2013
    Location
    Melbourne
    MS-Off Ver
    Excel 2013
    Posts
    173

    Re: Excel 2013. All sheets being automatically changed to Currency format

    Hi, I had the same problem, also with 2013 version. Unfortunately I couldn't find any other way to fix it other than re-build a fresh version of the file.

  3. #3
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Europe
    MS-Off Ver
    Office 2021 - Win10
    Posts
    1,007

    Re: Excel 2013. All sheets being automatically changed to Currency format

    Hi,
    Following code is useful for deleting all sheets formats...
    Please Login or Register  to view this content.
    Sub DontForgetThese()
         If Your thread includes any code Then Please use code tags...
         If Your thread has been solved Then Please mark as solved...
         If Anybody has helped to you Then Please add reputation...
    End Sub

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel 2013 Automatically insert a row when the last formatted row is used
    By lisakay in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-21-2013, 02:46 PM
  2. Automatically transfer data from one sheet to another in a workbook - Excel 2013
    By WGBarry in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-19-2013, 01:03 PM
  3. Letter / number codes automatically setup by Excel (2013)
    By drpiso in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-30-2012, 07:58 AM
  4. Replies: 2
    Last Post: 11-04-2012, 04:57 AM
  5. Automatically set all CURRENCY format to only one selected in one dropdown list
    By jasonofshanghai in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-11-2012, 08:42 AM

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