Creating Custom Number formats in Excel for Web

[Liliia_Swann]

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 by using formula (=A1+1) it works absolute fine. However our company uses web version of excel and I can not customize the number format in this version, the ref numbers work it selves if i copy and paste  from Full version of Excel, however if I want to create the LSL number in the Web Excel it says  'Creating custom number formats isn't currently supported in the web version of Excel'.

Please advise. 

[#2]

@Liliia_Swann 

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...

[#3]

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!

[#4 · Accepted solution]

@Liliia_Swann 

If I understand the desired format correctly, you might use something like:

="LSL "&TEXT(A1,"0000-00")

[#5]

Thanks, All sorted now.

[#6]

You're welcome! Thank you for the feedback.