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")
Exactly what it says. You can use custom number formats in Excel Online, but not create them. You do need the desktop version for Windows or Mac to do the latter...
- 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.
