Entering a Number with Leading Zeros

Postoje razni načini da se unesu intedzeri koji pocinju sa 0

If you want to apply a numeric 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. Izaberi Izmijeni - Pronađi i zamijeni

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

  4. In the Replace box, enter &

  5. Obiljezite Regularni izrazi tick box

  6. Mark the Current selection only tick box

  7. Mark the Replace All tick box

Please support us!