Show hidden zero on left

Post Reply
Hisham Ahmed
Posts: 15
Joined: Wed Feb 09, 2022 12:46 pm
Location: Egypt - el behera - el delingate

Show hidden zero on left

Post by 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 ?
Attachments
show hidden zero .mp4
What is the cause for such problem
(1.3 MiB) Downloaded 113 times
SuperTech
SoftMaker Team
SoftMaker Team
Posts: 2933
Joined: Wed Mar 11, 2020 5:31 pm

Re: Show hidden zero on left

Post by SuperTech »

The simplest way is to add ' before leading zero, which will allow leading zero.
Hisham Ahmed
Posts: 15
Joined: Wed Feb 09, 2022 12:46 pm
Location: Egypt - el behera - el delingate

Re: Show hidden zero on left

Post by Hisham Ahmed »

I want to apply it for all cells in one button
SuperTech
SoftMaker Team
SoftMaker Team
Posts: 2933
Joined: Wed Mar 11, 2020 5:31 pm

Re: Show hidden zero on left

Post by 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
Posts: 15
Joined: Wed Feb 09, 2022 12:46 pm
Location: Egypt - el behera - el delingate

Re: Show hidden zero on left

Post by Hisham Ahmed »

Can you explain this by screen recording , please?
Post Reply

Return to “PlanMaker 2021 for Android”