column format for numbers starting with zero

Joerg Schmidt

Hallo,

I use a column for postal codes (we habe 5 digits in Germany).

For some cities the postal code starts with a "zero" (= 0).

In the column the code only appears with 4 digits without the first 0.

How can I change the format so that the first digit also appears ?

Paul Newcome

How are you entering the data now?

Paul Newcome

Glad you got it working!

Paul Newcome

How are you entering the data now?

Joerg Schmidt

Dear all,

problem is solved. The first digit "0" disappeared with the import of the excel data.

You can add the "0" as first digit in Smartsheet without problem.

Thank you ;-)

Paul Newcome

Glad you got it working!