K KNMSRK New Member Dec 29, 2019 #1 Hi, I have data in number format but not in same length like 23 234 23456 I need a formula to add zeros before the number to make the length of number to 9 digits. Please advice Attachments Adding zeros before number.xls 25 KB · Views: 3
Hi, I have data in number format but not in same length like 23 234 23456 I need a formula to add zeros before the number to make the length of number to 9 digits. Please advice
K KNMSRK New Member Dec 29, 2019 #2 I have tried writing the formula... and it is giving required output.. Please find the attached file and advice that we can write the formula in any other way Attachments Adding zeros before number.xls 25.5 KB · Views: 4
I have tried writing the formula... and it is giving required output.. Please find the attached file and advice that we can write the formula in any other way
AliGW Well-Known Member Dec 29, 2019 #3 Your attachment will not open. Try this: =TEXT(A1,"000000000")
K KNMSRK New Member Dec 29, 2019 #4 Hi Ali I have tried this and it is giving required output =RIGHT("0000000"&A1,9) data is like below 23 234 2345 23456 formula is adding zero's before the number to make the length of the number to 9 ThnQ
Hi Ali I have tried this and it is giving required output =RIGHT("0000000"&A1,9) data is like below 23 234 2345 23456 formula is adding zero's before the number to make the length of the number to 9 ThnQ
Juniad Active Member Dec 30, 2019 #5 You could use custom formatting as well.. Go to custom formatting and enter 9 zeros in General field
V vletm Excel Ninja Dec 30, 2019 #6 KNMSRK Please reread Forum Rules https://chandoo.org/forum/threads/site-rules-new-users-please-read.294/ There are good hints what and how to do. eg You could explain, what would be connections with Your thread and Questions about Chandoo.org Products ?
KNMSRK Please reread Forum Rules https://chandoo.org/forum/threads/site-rules-new-users-please-read.294/ There are good hints what and how to do. eg You could explain, what would be connections with Your thread and Questions about Chandoo.org Products ?
K KNMSRK New Member Dec 31, 2019 #7 Juniad said: You could use custom formatting as well.. Go to custom formatting and enter 9 zeros in General field View attachment 64764 Click to expand... ThnQ Last edited by a moderator: Dec 31, 2019
Juniad said: You could use custom formatting as well.. Go to custom formatting and enter 9 zeros in General field View attachment 64764 Click to expand... ThnQ