dilawer5
Member
I need to add leading Zero to a column for two types of values.
1. Value containing numbers only which character length should be 9
2. Value containing Text which character length should be 10
I do it in excel with formula
=IF(ISNUMBER(A2),TEXT(A2,"000000000"),TEXT(A2,"0000000000"))
But when I need to do the same in Power Query I am not finding a way, due to the reason that power query is not identifying two different format types that is "Text" and "Number"
For example need to convert
12345 into 000012345
and
678910A into 000678910A
Please guide
Thanks
1. Value containing numbers only which character length should be 9
2. Value containing Text which character length should be 10
I do it in excel with formula
=IF(ISNUMBER(A2),TEXT(A2,"000000000"),TEXT(A2,"0000000000"))
But when I need to do the same in Power Query I am not finding a way, due to the reason that power query is not identifying two different format types that is "Text" and "Number"
For example need to convert
12345 into 000012345
and
678910A into 000678910A
Please guide
Thanks