\<bookmark_value\>zero values; entering leading zeros\</bookmark_value\>\<bookmark_value\>numbers; with leading zeros\</bookmark_value\>\<bookmark_value\>leading zeros\</bookmark_value\>\<bookmark_value\>integers with leading zeros\</bookmark_value\>\<bookmark_value\>numbers; changing text/number formats\</bookmark_value\>\<bookmark_value\>cells; changing text/number formats\</bookmark_value\>\<bookmark_value\>formats; changing text/number\</bookmark_value\>\<bookmark_value\>text in cells; changing to numbers\</bookmark_value\>

Entering a Number with Leading Zeros

There are various ways to enter integers starting with a zero:

If you want to apply a numerical format to a column of numbers in text format (for example, text "000123" becomes number "123"), do the following:

  1. Select the column in which the digits are found in text format. Set the cell format in that column as "Number".

  2. Choose \<emph\>Edit - Find & Replace\</emph\>

  3. In the Find box, enter ^[0-9]

  4. In the Replace box, enter &

  5. Check Regular expressions

  6. Check Current selection only

  7. Click Replace All

Please support us!