Forum Discussion
Solved
Creating Custom Number formats in Excel for Web
Hi, I am trying to create ref number, with letters LSL and numbers (LSL 1000-01). I can do this by using Full Version of Excel, I am customizing the number format "LSL"####-##, then in the next cell ...
If I understand the desired format correctly, you might use something like:
="LSL "&TEXT(A1,"0000-00")
Thank you so much for confirming this. I was feeling a bit lost there. Do you happen to know of any easier way to create the reference number? I'm new to this, and any help would be greatly appreciated!
If I understand the desired format correctly, you might use something like:
="LSL "&TEXT(A1,"0000-00")
- Thanks, All sorted now.
- You're welcome! Thank you for the feedback.