Show hidden zero on left

[Hisham Ahmed]

How can i show hidden zero values on the left ?
When i write for example 01156050478 on planmaker , i note it hide zero value . What should i do ?

[SuperTech]

The simplest way is to add ' before leading zero, which will allow leading zero.

[Hisham Ahmed]

I want to apply it for all cells in one button

[SuperTech]

In that case, please change the Number format of that range to Text, and then you will be able to add zero before numbers.

You can do this by selecting the range > touch and hold > Press Cell > Select Text in number format tab.

[Hisham Ahmed]

Can you explain this by screen recording , please?