Duration: 1:22

14 views

0

Here's how to Fix Number formatting not working in Microsoft Excel.

i. Here are some potential pros and cons of using number formatting in Excel:

Pros:

- Improves readability of numbers, dates, times, etc. by displaying them in a logical way

- Allows highlighting important digits or deemphasizing less important ones

- Can automatically insert symbols like dollar signs, percentages, commas for thousands

- Makes distinguishing between different types of numeric data easier (dates vs currency etc.)

- Aligns numerically formatted data in columns properly despite varying digits

- Displays insightful visual cues through color coding negative numbers in red, for example

- Facilitates creating customized formats for specific purposes

Cons:

- Formatted cells must be converted back to plain numbers for use in calculations

- Too much formatting can make spreadsheets visually cluttered

- Overuse of formatting could conceal the actual underlying raw numbers

- Needs to be reapplied if formulas fill formatted cells with new unformatted numbers

- Custom formats require additional time and skill to create and maintain

- Numeric formatting choices can be unclear or overwhelming for new users

- May cause data/calculation errors if users aren't aware numbers are still stored as base values

- Built-in formats may not provide enough specificity for some advanced users