Excel for the Web: Create Custom Reference Number Formats
Question details
The user needs to display sequential reference numbers with a custom prefix and zero-padded format in Excel for the web.
- Product
- Microsoft Excel for the web
- Device & OS
- not provided
- Scenario
- The user wants numbers to appear in a format such as LSL 1000-01 while maintaining a sequence that can be incremented in the worksheet.
- Observed behavior
- Excel for the web can display existing custom formats but does not currently provide an option to create new custom number formats.
Decide which cell contains the underlying number and which cell will display the formatted reference. Confirm the required prefix and digit pattern, such as LSL followed by four digits, a hyphen, and two digits.
Use a TEXT formula to display the custom reference format in Excel for the web
Use this workaround when you need the format immediately in Excel for the web without opening the desktop application.
The TEXT function converts the underlying number into a formatted text value. This reproduces the appearance of a custom number format, although the result cell contains text rather than a numeric value.
In cell A1, enter the starting number, such as 1.
In another cell, enter ="LSL "&TEXT(A1,"0000-00") and press Enter. The result displays as LSL 0000-01.
In the next sequence cell, enter =A1+1, then update the TEXT formula to reference that cell or fill the formula down to generate additional reference numbers.
Create the custom number format in desktop Excel
Use desktop Excel when the values must retain their numeric type while displaying the custom reference pattern.
Create LSL Reference Number Formats Directly in WPS Spreadsheet
WPS Spreadsheet lets you create custom number formats directly through Format Cells, so you can display sequential references such as LSL 0000-01 while keeping the underlying values numeric. It provides a familiar, lightweight spreadsheet workflow and supports Microsoft Excel files for seamless migration.
- 1. Open the workbook: Launch WPS Spreadsheet, open your workbook, and select the cells containing the reference numbers.
- 2. Open custom number formatting: Right-click the selected cells, choose Format Cells, and open the Number or Custom Format category.
- 3. Define the reference pattern: Enter "LSL "0000-00 as the custom format code, then select OK to apply it.
- 4. Generate the next reference: Enter the next underlying value or use a formula such as =A1+1 in the next cell, then copy the custom format down the sequence.

Frequently Asked Questions
Can Excel for the web create a new custom number format?
No. Excel for the web can display custom formats already stored in a workbook, but it does not currently provide the desktop Custom number format creation controls.
How do I display LSL 1000-01 with a formula?
If A1 contains the underlying number, enter ="LSL "&TEXT(A1,"0000-00") in another cell. Adjust the number in A1 or fill the formula down for additional references.
Will the TEXT formula keep the result as a number?
No. TEXT returns formatted text. Keep the original numeric value in a separate cell when you need calculations, sorting, or sequence formulas.
What custom format code should I use in desktop Excel?
Select Format Cells, choose Custom, and enter "LSL "0000-00. The quoted text adds the LSL prefix, while the zero placeholders control the displayed digits.
Can WPS Spreadsheet create this format directly?
Yes. Select the cells in WPS Spreadsheet, open Format Cells, choose the custom number format option, and enter "LSL "0000-00. The underlying values remain numeric.




