Results 1 to 6 of 6

TradingJournal Dashboard - Dynamic Decimal Points/Spaces

Threaded View

  1. #4
    Valued Forum Contributor
    Join Date
    08-31-2007
    Location
    SW Ireland
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2311 Build 16.0.17029.20068) 32-bit
    Posts
    540

    Re: TradingJournal Dashboard - Dynamic Decimal Points/Spaces

    The attached should be doing what you need.

    I added a column (column E) to the SYMBOLS section of the MasterData sheet which shows the type of number format for any particular symbol- you'll obviously need to check that these are updated.
    When you change column E on the Trades-Master sheet, the applicable formatting will be automatically applied to the relevant cells.
    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] TradingJournal Dashboard - Dynamic Total values
    By ecronic in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-18-2023, 08:52 AM
  2. [SOLVED] TradingJournal - Dynamic cell reference formula based on dropdown list selection
    By ecronic in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 07-04-2023, 02:24 PM
  3. [SOLVED] Only want 2 decimal spaces
    By StreekyD in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-17-2019, 02:06 PM
  4. [SOLVED] Formatting to 2 Decimal Spaces
    By sperry2565 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-27-2013, 12:27 PM
  5. Inserting spaces at certain points
    By spowell in forum Excel General
    Replies: 4
    Last Post: 01-26-2009, 09:08 PM
  6. Decimal Points
    By Leanne in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  7. Decimal Points
    By Leanne in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 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