Formatting Issues

Excel for the Web: Create Custom Reference Number Formats

Chanuka GeekiyanageChanuka Geekiyanage Nov 12, 2026 868 views

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.
Before you start

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.

Solution 1Recommended

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.

1
Enter the underlying number

In cell A1, enter the starting number, such as 1.

2
Apply the reference formula

In another cell, enter ="LSL "&TEXT(A1,"0000-00") and press Enter. The result displays as LSL 0000-01.

3
Increment the next number

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.

Formula result: The TEXT formula creates a text display. Keep the original numeric values in separate cells if you need to calculate, sort, or increment the underlying numbers.
Create custom formats in WPS Spreadsheet

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. 1. Open the workbook: Launch WPS Spreadsheet, open your workbook, and select the cells containing the reference numbers.
  2. 2. Open custom number formatting: Right-click the selected cells, choose Format Cells, and open the Number or Custom Format category.
  3. 3. Define the reference pattern: Enter "LSL "0000-00 as the custom format code, then select OK to apply it.
  4. 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.
Create custom number formats directly from Format Cells without relying on a TEXT workaroundKeep reference values numeric for sorting, calculations, and sequence generationOpen, edit, and save Microsoft Excel XLSX and XLS files with broad compatibilityUse a familiar spreadsheet interface for quick formatting and workbook migration
microsoft office alternative - wps office

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.