https://bugs.documentfoundation.org/show_bug.cgi?id=157933
--- Comment #2 from Eike Rathke <[email protected]> --- Numeric values _never_ preserve a leading zero and the maximum representable integer value is 9007199254740991 (2^53-1). As Mike said, either pre-format the cell with the Text format before entering the value, or in a General formatted cell enter the phone number as text string by prepending a leading ' apostrophe, like '012-345-678901 However, to display a numeric value such, you could use a format code like [<=9999999]###-####;[<=999999999]"0"##-###-####;"0"##-###-###-#### See also https://help.libreoffice.org/7.6/en-GB/text/shared/01/05020301.html?&DbPAR=CALC That would display 4567890 => 456-7890 34567890 => 03-456-7890 234567890 => 023-456-7890 1234567890 => 0-123-456-7890 91234567890 => 09-123-456-7890 891234567890 => 089-123-456-7890 Note that phone number formats differ between locales, so adjust the format code to your needs. Also, it is not possible to display the same number different depending on the net provider or area code, so differentiating between 012-3456789 and 0123-456789 is not possible. The only way to do it properly is using text instead of numeric. -- You are receiving this mail because: You are the assignee for the bug.
