File: /volume1/@appstore/Spreadsheet/ui/help/enu/sheet_formatting_data.html
<!DOCTYPE html>
<html class="img-no-display">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" >
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
<title>Office</title>
<link href="../../../../help/help.css" rel="stylesheet" type="text/css" />
<link href="../../../../help/scrollbar/flexcroll.css" rel="stylesheet" type="text/css" />
<script type="text/javascript" src="../../../../help/scrollbar/flexcroll.js"></script>
<script type="text/javascript" src="../../../../help/scrollbar/initFlexcroll.js"></script>
</head>
<body><h1>Formatting Data</h1><p>You can apply various data formats to cells, including numbers, currency, dates, and time. You can also adjust formatting based on locale settings or define custom formats.</p><h2><a name="numbers"></a>Format and Customize Numbers, Currencies, Dates, or Time</h2><h4>To apply a number, currency, date, or time format:</h4><ol> <li>Select the cells you want to format.</li> <li>Click <strong>Format</strong> in the top menu or right-click the selected cells and select <strong>Data format</strong>.</li> <li>Select one of the options.</li></ol><h4>To remove a format:</h4><ol><li>Select the formatted cells.</li><li>Click <strong>Format</strong> in the top menu or right-click the selected cells and select <strong>Data format</strong> > <strong>Automatic</strong>.</li></ol><h4>To customize a format:</h4><ol><li>Select the cells you want to format.</li><li>Click <strong>Format</strong> in the top menu or right-click the selected cells and select <strong>Data format</strong>.<ul><li><strong>More currency formats</strong>: Choose a currency from the list or search for one. Use the drop-down menu to select and preview the format.</li><li><strong>More date and time formats</strong>: Choose a format from the list (which includes the most commonly used formats for your locale).</li><li><strong>Custom formats</strong>: Choose a format from the list or enter a custom format in the text box.</li></ul></li></ol><h3>Custom Format Details</h3><p><strong>Separators</strong></p><p>You can separate digits with a comma (,) or a dot (.). Your custom format can consist of up to 4 parts separated by semicolons (;) in the following order:</p> <ol> <li>Positive numbers</li> <li>Negative numbers</li> <li>Zero values</li> <li>Text</li></ol><p>For example, if you type <b>#,##0;(#,##0);0.00;@</b></p><ul> <li>Positive numbers, such as 1235, will be displayed as <b>1,235</b>.</li> <li>Negative numbers, such as -1235, will be displayed within parentheses as <b>(1,235)</b>.</li> <li>Zero values will be displayed as <b>0.00</b>.</li> <li>Text will be displayed as typed.</li></ul><p><strong>Colors</strong></p><p>You can apply colors to specific data types by adding a color name in English in brackets (e.g., <code>[Green]</code>). The color names are not case-sensitive. Supported colors include:</p><ul> <li>Black (<code>[Black]</code>)</li> <li>White (<code>[White]</code>)</li> <li>Red (<code>[Red]</code>)</li> <li>Blue (<code>[Blue]</code>)</li> <li>Green (<code>[Green]</code>)</li> <li>Magenta (<code>[Magenta]</code>)</li> <li>Yellow (<code>[Yellow]</code>)</li> <li>Cyan (<code>[Cyan]</code>)</li></ul><p>For example, if you type <b>[Green]#,##0;[Red]#,##0;0[Blue];@[Cyan]</b></p><ul> <li>Positive numbers will be displayed in green.</li> <li>Negative numbers will be displayed in red.</li> <li>Zero values will be displayed in blue.</li> <li>Text will be displayed in cyan.</li></ul><h2><a name="locale"></a>Format with Locale Settings</h2><p>Languages and geographic regions have different conventions for formatting numbers, currency, and time. Synology Office provides 70 locale options.</p> <h4>To change the default locale for all spreadsheets:</h4><ol> <li>Click the <strong>Account</strong> icon in the lower-left corner of the screen.</li> <li>Go to <strong>Package settings</strong> > <strong>Synology Office</strong> > <strong>Default locale</strong>.</li> <li>The default locale is initially set to match your browser’s locale. To change it, select a new locale from the drop-down menu.</li></ol><div class="section"><h4>Note:</h4><ul> <li>If your browser's locale is not supported by Office, the default locale will be English (United States) - en-US.</li></ul></div><h4>To set a custom locale for a specific spreadsheet:</h4><ol> <li>Click <strong>File</strong> in the top menu.</li> <li>Select <strong>Spreadsheet settings</strong> and select a locale from the drop-down menu.</li></ol></body>
</html>