[Solved] Leading Zero in Base
[Solved] Leading Zero in Base
Hi I am unable to get the leading zero to show in a form. I have tried added leading zero in format and also changed to text. Nothing doing.
Last edited by Mickey12 on Tue Apr 28, 2020 12:13 pm, edited 1 time in total.
Open Office 4.1.7 on Windows 10
Re: Leading Zero in Base
If the table column type is numeric (integer, decimal, floating point etc), you can use either a formatted field or a numeric field and format to your liking.
If the table column type is text, you have to enter the leading zero because the text "0123" differs from the text "123". In this case you should use a pattern field.
If the table column type is text, you have to enter the leading zero because the text "0123" differs from the text "123". In this case you should use a pattern field.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice