Entering numbers as text
If a number is entered in the format 01481, Calc will drop the leading 0.To preserve the leading zero, in the case of telephone area codes for example, precede the number with an apostrophe, like this: '01481.However, the data is now regarded as text by Calc.Arithmetic operations will not work on it.It will either be ignored or will produce an error of some kind.
|
TIP
|
Numbers can have leading zeros and be regarded as numerical entries if the the cell is formatted appropriately. Right-click on the cell and chose the Format Cells > Numbers. Adjusting the leading zeros setting can add leading zeros to numbers.
|
