Thread
:
Format Number to Text
View Single Post
#
1
arno
Posts: n/a
Hi Roni wrote:
If in sheet1 the number is 10, in sheet2 it will be 00000010 (text
format).
How can I change the format in sheet1 to 8 character text like the
format I have in sheet2?
=text(a1, "00000000")
arno
Reply With Quote