• About cell formatting
• Conditional Formatting
• To adjust cell height
• To adjust cell width
• To align a column of cells
• To align numbers and text in a cell
• To capitalize cell contents
• To change a cell's font
• To change a cell's type
• To change the separator for date cells
• To create a user defined underline
• To define cell options globally
• To distribute cell contents evenly
• To format the appearance of negative values
• To format the appearance of positive values
• To format the appearance of zero values
• To print a currency sign inside a cell
• To separate large currency values with a comma
• To shade a cell
• To shade a column of cells in Form mode
• To shade multiple cells
• To underline a cell
• To underline the currency symbol

Changing The Separator for Date Cells

1. Double-click the date cells you want to modify.
2. Click Date.
3. In the Date Style box, select the format for the date. Use a format with either slash (DD\MM\YY) or dash (DD-MM-YY) separators.

Tip

• If you prefer to use the Regional Settings specified in the Control Panel, you can change the separator globally for your computer.

Related Topics

• About Cell Formatting