How to append 0s before a set field of 10 characters when the characters inserted are 4

[siddharthsopori]

Hello ,
How to append 0s before a set field of 10 characters when the characters inserted are 4 .

Eg. the field accepts the character length 10 , so ,
if the value is 12345 , for the remaining spaces should pe appended by 0s resulting in
0000012345 .

ab = 00000000ab

monkey = 0000monkey

9876543 = 0009876543 .

Help would be really appreciated

Regards
Sid

 

[Khalid NGO]

Hi Siddhart,

You can use custom format by using Ctrl+1 on the cells.
Ctrl+1 = Format Cells > Number > Custom

enter 0000000000 press ok

Best Regards,
Khalid

 

[Khalid NGO]

Hope this will clear the situation

 

[siddharthsopori]

Thanks a lot Khalid .
You saved my day