Results 1 to 7 of 7

Cells that I format as Currency automatically revert to Number on the first attempt

Threaded View

  1. 08-22-2018, 03:50 PM #1
    MetroBOS
    MetroBOS is offline
    Forum Contributor
    Join Date
    05-21-2014
    Location
    United States
    MS-Off Ver
    Office 365 on Windows 10
    Posts
    122

    Question Cells that I format as Currency automatically revert to Number on the first attempt

    Whenever I try to format cells as Currency, it formats the cells as Number instead. If I try to format them as Currency again, it works on the second try.

    This happens 99% of the time, and the other 1% of the time it works like it should but it seems to be completely random when it does work.

    Does anyone know why this would happen?
    Attached Files Attached Files
    Last edited by MetroBOS; 08-22-2018 at 04:44 PM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Return Number in Currency format
    By felizeng in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-25-2017, 05:27 PM
  2. Attempt to automatically place a blank cell amongst cells or columns or rows
    By PivotTablePSHomage in forum Excel General
    Replies: 2
    Last Post: 02-07-2015, 06:25 PM
  3. [SOLVED] Currency with number in certain format
    By pansovic in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-08-2014, 12:17 AM
  4. Excel 2013. All sheets being automatically changed to Currency format
    By lynchy in forum Excel General
    Replies: 2
    Last Post: 12-02-2013, 10:05 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
  6. How do I revert cells to blank automatically on spacific days?
    By Conker10382 in forum Excel General
    Replies: 5
    Last Post: 05-25-2006, 12:20 PM
  7. [SOLVED] why does currency format change to number format?
    By Cassie in forum Excel General
    Replies: 3
    Last Post: 03-18-2005, 03:06 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1