Format Number to Text
Hi All,
Need your advise for the following: I have numbers in column A ranging from 1 to 99999999 in sheet1. In sheet2, I have the numbers in text format (8 character). 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? I can format it to 8 digit number using format cell, custom, then I put 00000000 but I do not know how to convert it to 8 character text. Thanks, Roni |
Let me clarify: I can do that using combination of if and concatenate
function.... Any other ideas how to do this? Roni |
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 |
All times are GMT +1. The time now is 09:30 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com