How to Add leading Zeros to a column which has String Value
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
How to add leading Zeros to a column which has 6 digit number
like "123456" I need to make it as "0000000123456" - I need to make this number as 13 digit number entire Row
Numbers in the column like
123456
654321
1111111
2345
112
Wanted to convert like below all the values in the particular column
0000000123456
0000000654321
0000000111111
0000000002345
0000000000112
Solved! Go to Solution.
- Labels:
- Tips and Tricks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Ram_RK
Please use the function Padleft() to get the desired output.
Step 1: Formula tool
PadLeft(ToString([Column A]),13,'0')
Many thanks
Shanker V
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks Shankar I got that
I applied this formulae as it contains Text also and the formulae should Avoid text
In formulae Tool >>>>>>
if IsInteger([Value]) then
PadLeft([Value], 13, '0')
else
[Value]
endif
