# Questions tagged [cell-format]

Cell-level setting in a spreadsheet that specifies its data type and describes the default way it will be displayed. Use only if the cell format is central to the question. Use [text-formatting], instead, for questions pertaining to creating or preserving the format of text or data. For questions pertaining to displaying cells differently under specific conditions, use [conditional-formatting] instead.

**0**

**2**answers

### How to Fill One Cell With Date Based On Corresponding Cell

**0**

**0**answers

### Number format #.# - Excel bug?

**1**

**1**answer

### Can this cell numeric value be “displayed” in a different way in Excel?

**0**

**1**answer

### How to match cell value to cell format

**0**

**1**answer

### Is thеrе any wаy tо propеrly displаy nеgativе timе spаns in Exсеl?

**0**

**0**answers

### Excel/VBA - Fill color of a cell in pivot table according to column value in source table

**0**

**1**answer

### How to change the formatting of German letters in Excel?

**0**

**0**answers

### How to convert dated time to fraction hour format

**1**

**2**answers

### Excel: different number of digits in the same column Excel

**0**

**0**answers

### Excel: Fake Blank Cell (cell has no content, nothing in the function box, but not recognized as a blank cell)

**0**

**1**answer

### Combine merge content in Excel

**0**

**1**answer

### How can I avoid an Excel cell's being automatically formatted as currency upon entering financial functions such as PV, FV, PMT, NPV…?

**3**

**2**answers

### Display vulgar fractions with a colon for aspect ratios

**0**

**0**answers

### I want to format numers as powers of 10 on a chart

**0**

**0**answers

### Why is 1st January 2020 formatted strangely in Excel Pivot Table?

**1**

**0**answers

### How do I turn off autoformat OpenCalc / OpenOffice Spreadsheets

**0**

**2**answers

### Dynamic rule to change the color of a cell when a check box is true

**0**

**0**answers

### Duplicating certain rows while retaining variable values (except for 1 cell)

**0**

**1**answer

### Excel custom number format: Is there a way to show the number in basis points (bps)?

**1**

**2**answers

### Format cell as days plus time duration

**2**

**0**answers

### I am unable to enter 6E029 in a cell in Excel

**1**

**2**answers

### Suspect behaviour getting cell width in Excel

**0**

**0**answers

### Cells show number as text despite number format

**1**

**3**answers

### Excel cell custom format

**0**

**1**answer

### Excel apply complicated formula to existing cells value without copy/paste

**0**

**0**answers

### Excel 2016: All cells dark by default

**2**

**1**answer

### Percentage increase in excel for cell in hour format

**2**

**1**answer

### Filtering empty cells

**2**

**1**answer

### How do I format time to MM:SS in Libre Office Calc?

**0**

**1**answer

### Need to Stop Excel From Reformatting Numbers

**2**

**1**answer

### Multiple conditions in custom format

**0**

**0**answers

### Hide irrelevant decimal fractional part of numbers in spreadsheets

**1**

**2**answers

### Microsoft Word “DOT” not showing up after the table

**1**

**2**answers

### How to Format Excel Cells for Engineering Notation?

**1**

**1**answer

### Put a list of cell data in a single cell based off of specific values

**1**

**1**answer

### Excel: Different formatting on different values in same cell

**1**

**2**answers

### How can I make an Excel cell with a DATE format accept dashes?

**1**

**2**answers

### Excel 2013 - Detect Cell Currency Format

**0**

**1**answer

### excel clear sets format as accounting

**1**

**1**answer

### Merging cells accross multiple rows in Excel

**0**

**2**answers

### Can I create a multi-color cell without a gradient in Excel?

**0**

**1**answer

### Excel date format with abbreviated month without the dot

**1**

**3**answers

### How do I format a number in an “=CELL” type of statement?

**0**

**0**answers

### Excel automatically changes font in a cell after text input

**1**

**1**answer

### How to format cells to display two places after the leading zero in Excel?

**3**

**2**answers

### LibreOffice Calc: conditional formatting based of column / cell value

**0**

**2**answers

### Excel 2007 Cut and paste formula or value without changing cell formatting - paste options greyed out

**0**

**2**answers

### How to identify the original cell location that contains the Max information that my formula gives me?

**1**

**2**answers

### How to calculate song lengths in a spreadsheet?

**7**

**2**answers