From 6193c8a5f97aa5d6922b412019c6da0bfda97590 Mon Sep 17 00:00:00 2001 From: Laurent Balland-Poirier Date: Sat, 13 Aug 2016 12:56:21 +0200 Subject: Add format star to repeat character Number format modifier (*) Change-Id: I9362ce7f8e87b2f9b957085da241c040316ed813 Reviewed-on: https://gerrit.libreoffice.org/28100 Reviewed-by: Olivier Hallot Tested-by: Olivier Hallot --- source/text/shared/01/05020301.xhp | 4 ++++ 1 file changed, 4 insertions(+) (limited to 'source/text/shared') diff --git a/source/text/shared/01/05020301.xhp b/source/text/shared/01/05020301.xhp index 934a9bf915..45bfdb86ce 100644 --- a/source/text/shared/01/05020301.xhp +++ b/source/text/shared/01/05020301.xhp @@ -193,6 +193,10 @@ To include text in a number format that is applied to a cell that might contain text, enclose the text by double quotation marks (" "), and then add an at sign (@). For example, enter "Total for "@ to display "Total for December". Spaces To use a character to define the width of a space in a number format, type an underscore ( _ ) followed by the character. The width of the space varies according to the width of the character that you choose. For example, _M creates a wider space than _i. +To fill free space with a given character, use star character (*) followed by this character. For instance: +*\0 +will display integer value (0) preceded by as many as needed backslash characters (\) to fill column width. For accounting representation, you may left align currency symbol with a format similar to: +$_-* 0.--;$-* 0.--;$_-* - Color To set the color of a section of a number format code, insert one of the following color names in square brackets [ ]: -- cgit