Description: For example, one million in English it is 1,000,000.00, but in Dutch it is 1.000.000,00. Some people use a space instead of the dot or the comma, so: 1 000 000,00 or 1 000 000.00. Is it possible to enter this new item in the cell formatting. Maybe we start a new international quotation. Actual Results: There is no problem Expected Results: I have to do it myself. ;-) Reproducible: Always User Profile Reset: No Additional Info: I hope we start an international breakthrough.
Where even is your problem? The default formatting depends on the current locale, either as set under Tools -> Options -> Language Settings -> Languages, or if Default there then inherited from the system locale. Individual cells can be attributed with a specific locale from the number format dialog (Ctrl+1 or Format -> Cells..., Numbers, Language).
Dear Eike, Thank you for the quick response. I have no problem, but an idea. The space instead of the comma or the dot doesn't exist. So, maybe a space in every language is a possibility. Just to set a new international quotation. ;) Yours faithfully, Louis DeWald
Ah so you want a space instead of what the locale says to use as group separator.. as such I'm closing this as a duplicate of bug 46448 in case that gets ever implemented. *** This bug has been marked as a duplicate of bug 46448 ***
(In reply to Louis DeWald from comment #0) > Is it possible to enter this new item in the cell formatting. I know this is closed already, but IMHO it should not be a dupe of tdf#46448, as the request of using a space as digit group delimiter is already possible in LO 7.6. For example, if I have the following number format code: #,##0.00 I can replace that comma to a space character: # ##0.00
Dear Ady, Thank you for your solution. I did it and it worked! Thank you again. Yours faithfully, Louis DeWald
That (using any character that is not the locale's group separator) does not act as a group separator though, but as literal character at that position only. The number 1234567.89 is displayed as 1234 567.89 not 1 234 567.89 Furthermore it _always_ outputs the space character also for smaller numbers, e.g. the value 1 would produce the output string " 1.00", you usually don't see with right aligned numbers but would with left aligned or when copy-pasting through clipboard.