Excel Guides

When is Currency Not Currency in Excel

Currency is a type of data that can be stored in a cell in Excel. Currency values can be formatted to appear as currency symbols, such as $ or , and can be used in mathematical formulas. However, there are some circumstances where a cell containing currency values may not be recognized as such by Excel.

One common reason why currency values may not be recognized as such is because the cells are not formatted correctly. In order for Excel to recognize a cell as containing currency values, the cell must be formatted as "Currency". This can be done by selecting the cell, and then going to the "Number" tab in the "Format Cells" dialog box. Under "Category", select "Currency", and then choose the desired symbol and number of decimal places under "Symbol".

Another reason why currency values may not be recognized as such is because the cells are not entered correctly. When entering currency values into cells, it is important to use the correct number of decimal places. For example, if a cell is formatted to use the dollar sign ($) as the currency symbol, and two decimal places are selected under "Symbol", then all values entered into that cell must use two decimal places (e.g. $12.34, $0.56). If more or fewer than two decimal places are used, Excel will not recognize the cell as containing currency values.

Finally, another reason why currency values may not be recognized as such is because they are entered into cells that are not adjacent to each other. In order for Excel to recognize a range of cells as containingcurrency values, the cells must be adjacent to each other (i.e. they must be next to each other horizontally or vertically). If they are not adjacent to each other, then Excel will treat them as if they were individual cells and will not recognize them as part of a range ofcurrency values.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.