Thanks. That was very helpful. My work has fund numbers which are six numbers in length. The earlier fund numbers have zeroes in front, and I've been struggling with the silly green triangles for ages, which irritate me and always reappear. It's never been satisfactory to me to treat the numbers as text and to use a leading apostrophe, so will be using the special mask function from now on. Ta!
Need to learn how to add a zero before a number in Excel? Let Sharyn show you how.
Thanks. That was very helpful. My work has fund numbers which are six numbers in length. The earlier fund numbers have zeroes in front, and I've been struggling with the silly green triangles for ages, which irritate me and always reappear. It's never been satisfactory to me to treat the numbers as text and to use a leading apostrophe, so will be using the special mask function from now on. Ta!
Fantastic Jo! So happy it helped!
This is so helpful
You're welcome! So glad it helped!
Insightful....work done
Thank you!
Great insight. Thanks.
So glad it helped!
Awesome thank you soo much.
You are so welcome!
Thankyou so much ...the video is helpfull...❤️
So glad it helped :-)