formatting - Format a number with optional decimal places in Excel - Super User

formatting - Format a number with optional decimal places in Excel - Super User

瀏覽:740
日期:2024-07-09
Apply Conditional Formatting for non-decimal numbers. For example, A1 is the target cell. Format A1 as "###,###.00". This will be used for decimal number. Define Conditional Formatting for non-decimal numbers. Condition: Cell Value equal to =TRUNC(A1)....看更多