+ Reply to Thread
Results 1 to 2 of 2

Cell Formatting keeps disappearing

  1. #1
    Registered User
    Join Date
    MS-Off Ver
    Office 2016

    Cell Formatting keeps disappearing

    I will format a column using the header so the whole column is formatted. I choose the header of a column and while it is active I right click in the active column that is grey. I then choose format column.
    I'm either making the column currency, number or percent. I then always center by using by using the align tabs in the top tool bar.

    I check and everything is just the way I want it. Then later on or next day. All my changes are gone currency turns to numbers and aligned to the right. This just started happening recently. Any tips on what I'm doing wrong or why a succesful format comes un done?

    Thank you!

  2. #2
    Forum Contributor
    Join Date
    California, USA
    MS-Off Ver
    Excel 2010

    Re: Cell Formatting keeps disappearing

    Re: ``currency turns to numbers and aligned to the right``

    Assuming default horizontal formatting, data that is right-aligned is usually text, even if it might look like numbers to you.

    Confirm with formulas of the form =ISTEXT(A1) or =ISNUMBER(A1).

    Looks can be deceiving; and the format of the cell does not matter.

    Re: ``currency turns to numbers and aligned to the right``

    My guess: you save the Excel file "as CSV", then reopen it later.

    A CSV file is not really an Excel file, even though Windows shows an Excel icon for the file. That merely means that Excel is the default application to open the file.

    A CSV file is simply a text file of a certain form. A text file has no formatting information.

    When Excel opens the text file, it interprets the (usually) comma-separated data in the same manner as if we had entered it manually.

    If Excel cannot interpret "numeric" text as a number, it enters the data as text.

    For example, if your system uses comma for the "decimal separator" (radix point) and period for the thousands separated, but you format the cells with the reverse appearance, then save as CSV and reopen the file, Excel might not be able to interpret the data as numeric, or it might misinterpret some data.

    The best remedy might be: save as a truly Excel file ("xls", "xlsx" or "xlsm"), not as CSV.
    Last edited by curiouscat408; 10-28-2021 at 08:03 PM.

+ 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. conditional formatting disappearing text
    By Jnehra in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-06-2021, 01:52 PM
  2. Replies: 11
    Last Post: 02-25-2019, 06:29 AM
  3. [SOLVED] Disappearing in-cell instructions
    By HollyB1285 in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 12-17-2015, 11:28 AM
  4. Formulas Disappearing after Cell reference changes
    By paxile2k in forum Excel General
    Replies: 4
    Last Post: 12-23-2010, 09:38 PM
  5. Disappearing in-cell instructions
    By mrs179 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-14-2008, 05:33 PM
  6. Disappearing in-cell instructions
    By mrs179 in forum Excel General
    Replies: 2
    Last Post: 07-07-2008, 12:20 PM
  7. [SOLVED] Border Formatting Disappearing when data entered into cell
    By Orgelfreude in forum Excel General
    Replies: 0
    Last Post: 10-10-2005, 09:05 PM

Tags for this Thread


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