# 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**

**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

### Excel Not UnHiding Cells

**0**

**0**answers

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

**0**

**0**answers

### 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

**0**

**0**answers

### Excel 2016 - Format Painter applies only to first row

**2**

**0**answers

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

**1**

**1**answer

### 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

**0**

**0**answers

### How can I get, in R, features of Excel cells?

**0**

**0**answers

### MS Word: New Table Rows Copying Formatting from Other Rows

**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

**0**

**1**answer

### 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?

**6**

**2**answers

### How to display multi lines in an Excel cell WITHOUT wrapping

**7**

**1**answer

### How to eliminate auto single quote added to formula

**0**

**0**answers

### Text in table cells is not correctly aligned horizontally

**4**

**1**answer

### Custom negative sign symbol in Excel?

**19**

**4**answers

### What Colours Are Available To Use With a Custom Number Format EXCEL

**0**

**3**answers

### Excel inconsistently changing the format of DATE cells

**0**

**0**answers

### Undoing Text Formatted as Dates

**2**

**1**answer

### How do I conditionally format a cell based on different cell results?

**2**

**2**answers

### How to adjust row heights depending of cell content?

**-1**

**2**answers

### General and Text Format covert data to exponential

**0**

**2**answers