# 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

### Merging cells accross multiple rows in Excel

**0**

**1**answer

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

**2**

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

**0**

**0**answers

### How to make custom currency in LibreOffice Calc?

**1**

**2**answers

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

**3**

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

**15**

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

### Creating the difference of two numbers without a sign in Excel

**1**

**0**answers

### Show lines in merged cell

**0**

**0**answers

### How to change individual cell heights in a table using Word 2016?

**0**

**0**answers

### Excel 2010 Formatting Challenge

**0**

**0**answers

### Merging cells in Excel not working like it used to

**3**

**1**answer

### Excel 2016 changes my cell value

**1**

**2**answers

### Align numeric values on the decimal point

**0**

**2**answers

### Copy and paste without unlocking the protection in excel

**-1**

**1**answer

### inserting a decimal point to number in excel

**0**

**2**answers

### Excel SUMIFS Formula Sequential Date Criteria?

**0**

**0**answers

### Two identical values not treated equally in Excel

**2**

**1**answer

### LibreOffice Calc: how to pad number to fixed decimals when used within formula?

**1**

**0**answers

### Replicate cell format as well as value in referenced cell

**1**

**0**answers

### Show Excel Cell Only If Another Has Data

**2**

**3**answers

### Display thousand percent in MS-Excel

**0**

**1**answer

### How to have Excel recognize date in format MMM YYYY (e.g. Mar 2015)?

**0**

**1**answer

### Formatting time s:mm.00 in Excel (Office 2010) and graphing

**0**

**1**answer

### Excel positives values to red

**1**

**1**answer

### Cell Formatting, 0.00 where blank value

**0**

**1**answer

### h:mm:ss for workout data in MS Excel for Mac

**1**

**1**answer

### StackExchange Number Format in Excel

**1**

**1**answer

### Excel Edit Mode: Time without seconds

**0**

**1**answer

### Excel reformatted numbers to times

**0**

**1**answer

### How does Excel handle the h:mm:ss format?

**0**

**2**answers

### Lock formula but allow colouring of the cell?

**2**

**2**answers

### Date format worldwide in Excel

**3**

**1**answer

### Excel - Convert dates and currency as text to Excel dates and numbers respectively

**0**

**3**answers

### Formatting Times (durations) in Excel

**2**

**3**answers