There have been a couple of enquiries to the Forum in recent days mentioning a problem with having a leading zero in a number in a Openoffice Calc document (eg with a mobile telephone number 0 with three digits a space three digits a space and three digits) in a column.. I cannot find the actual concise answer to this problem that I first read so will put it in my words. Highlight the column in a Calc document that you want to use for these numbers. Go to .> Format > Cells > Numbers > General > Format code towards the bottom of the window. Enter zeros 0000 space 000 space 000 Click OK When you insert a number leaving spaces where required the result will be 0442 876 543. If the number is not inserted with spaces it will appear as 0442876543. In a saved document with numbers without a leading zero to the numbers and needing one - If the column is high lighted and the formatting is done as above a zero will be placed in front of each number. If the column also contains landline numbers which contain only eight numbers two zeros will be placed in front of these numbers. The decision has to be made "with or without zeros" I hope this is clear enough to be of use to some members of the Forum. Jean
