How to add apostrophe in beginning of the cell so the 0 number is not gone


#1

Hi
I would like to add apostrophe in the begin cell so the 0 number is not gone.
for example
00000000750920171031000034
but after i use write range into another excel the data will be
750920171031000034
is there any way to do that? I’m try using for each row but still not successful (maybe i’m not doing it right)

Thanks for your help and appreciate the feedback

Cheers :smiley:


#2

Hey @delf

Actually when you write a such a big data what excel do it converts into a number so by appending " ’ " you are making it to accept it as a text value to excel.

you can achieve it simply while writing values append " ’ " at the beginning with the value.

a vert quick sample for u - Text Col Write value.xaml (6.0 KB)

Regards…!!
Aksh


#3

Hi @aksh1yadav

Thanks for your reply
I already look your example and its works but im still wondering not just my example but the entire column (e.g. P5:P700)
3
but i got the error.
is this the correct one or need to make something else?

Thanks
Cheers


#4

you are passing a whole table mate so you are getting error. that was for each value you are writing into the datatable :slight_smile: or as per your needs.

REgards,!!
Aksh


#5

Thanks @aksh1yadav for your reply…
So do you have any suggestion for add the apostrophe for the whole column ?
Thanks mate

Cheers
Delf


#6

Yeah one possible way which took me less time… in busy schedule to update existing column values.

For your Reference: Text Col Write value- part 2.xaml (9.2 KB)

Regards…!!
Aksh


#7

Hi @aksh1yadav

Thanks for the reply and it works with that .

Thank you very much for your solution.

Cheers