Hai Tio,
Range("g6").value="'" & range("g6").value
Regards,
Kid
2017-08-14 13:39 GMT+07:00 Tio Adi Bayu Adjie [email protected]
[belajar-excel] <[email protected]>:
>
>
> Tio Adi Bayu Adjie has shared a OneDrive for Business file with you. To
> view it, click the link below.
>
> <https://tmtgroup-my.sharepoint.com/personal/tio_adjie_ptssb_co_id/_layouts/15/guestaccess.aspx?docid=14c022c1c0c714fc6a155fba2355d0872&authkey=AYzeAheQZLT-eMCq-sgrPYo>
> Convert number to text (string).xlsm
> <https://tmtgroup-my.sharepoint.com/personal/tio_adjie_ptssb_co_id/_layouts/15/guestaccess.aspx?docid=14c022c1c0c714fc6a155fba2355d0872&authkey=AYzeAheQZLT-eMCq-sgrPYo>
>
> <https://tmtgroup-my.sharepoint.com/personal/tio_adjie_ptssb_co_id/_layouts/15/guestaccess.aspx?docid=14c022c1c0c714fc6a155fba2355d0872&authkey=AYzeAheQZLT-eMCq-sgrPYo>
>
> Dear Be-Exceller,
>
> Bagaimana code vba mengkonversi numeric (angka) yang ada di range G6 jadi
> text ? Format angkanya tidak dirubah manual jadi text. Saya sudah coba
> bikin code vba dan function, tapi tidak berhasil juga. File terlampir.
>
>
> Terima kasih.
>
>
>
