In modern Excel, XL is column number 636: the column letters are a base-26 label, so X is 24 and L is 12, giving 24 × 26 + 12 = 636. If you mean XL as a Roman numeral rather than a column label, it means 40. Excel can calculate either value, but the right formula depends on which meaning you intend.
Two meanings of XL in Excel
The wording “XL number” can point to two different things. In a worksheet reference, XL is a column heading, just like A, Z, AA, or XFD. A column heading identifies where a cell is; it is not itself a value in a worksheet cell. Excel assigns every column a sequential number, and XL is column 636.
Outside the grid, XL is also the Roman numeral for 40. That interpretation matters if you have text such as “XL” in a cell and want Excel to treat it as a numeral. The distinction is useful: a column label can be translated with the COLUMN function, while a Roman numeral can be translated with ARABIC. Neither interpretation is universally the intended one, so consider the context of the question or the data you are working with.
For a quick check:
- Column XL: number 636.
- Roman numeral XL: number 40.
How Excel column numbers work
Excel labels columns using letters, but the labels work like a base-26 counting system with one important difference from ordinary place-value notation: there is no zero letter. A is 1, B is 2, and Z is 26. After Z, Excel starts a two-letter label at AA, which is 27. The next labels are AB, AC, and so on; after AZ comes BA.
For a two-letter column, the first letter represents a group of 26 columns, and the second letter adds the position within that group. X is the 24th letter, so the columns before the X group account for 24 × 26 positions. L is the 12th letter. Therefore XL is (24 × 26) + 12, or 636. This is why simply adding the alphabet positions, 24 + 12, would be incorrect.
The same rule extends to labels with three letters. For instance, a three-letter label has a 26-squared place, a 26 place, and a final position. You do not usually need to work these out by hand: Excel can return a column number from a cell reference. Understanding the pattern does help explain why column labels change from Z to AA rather than stopping at 26.
Find the number for column XL
In Excel for Microsoft 365 on Windows, use the COLUMN function with a cell reference in the XL column. The formula can be entered in any ordinary worksheet cell; it returns the column number of the referenced cell, not the row number.
With the reference XL1 in the formula, enter =COLUMN(XL1). The result is 636. XL1 is simply a convenient cell in column XL; XL2 or XL100 would return the same column number. The row in the reference does not affect the result.
You can use the same approach for other headings. For example, COLUMN(A1) returns 1, COLUMN(Z1) returns 26, and COLUMN(AA1) returns 27. This is often the quickest option when you know the column letters and only need to check their numeric position. If a workbook has hidden columns, the function still reports the column’s position in the worksheet grid; hiding a column does not renumber the remaining columns.
Convert column letters stored as text
Sometimes the label is in a cell rather than typed directly into a formula. Suppose A2 contains the text XL. To turn that text into a cell reference, append a row number and pass the reference to INDIRECT.
With the column letters in A2, enter =COLUMN(INDIRECT(A2&"1")). If A2 contains XL, the formula constructs the reference XL1 and returns 636. In an Excel formula, the ampersand joins the text in A2 to the text “1”; the HTML ampersand is displayed here as & in the encoded formula.
This method expects A2 to contain a valid column label for the current worksheet version. Extra spaces, punctuation, or an invalid label can cause a reference error. If the data may contain spaces, clean or validate it before building the reference. Also note that INDIRECT is a volatile function: Excel recalculates it whenever recalculation occurs, which can matter in a large workbook with many such formulas. For a small lookup or one-off conversion, it is usually straightforward; for large datasets, consider whether a nonvolatile design is possible.
Convert a column number back to letters
The reverse task is also common: a number such as 636 is stored in a cell, and you need the corresponding letters XL. ADDRESS can create a cell reference from a row number and a column number. Its fourth argument, 4, requests a relative-style reference without dollar signs. Removing the row number leaves the column label.
With the column number in A2, enter =SUBSTITUTE(ADDRESS(1,A2,4),"1",""). If A2 contains 636, ADDRESS produces XL1 and SUBSTITUTE removes the 1, so the result is XL. The input should be a valid column number for the worksheet; for example, a value above Excel’s column limit cannot identify an existing column.
This formula is handy when creating reports, labels, or instructions that need a column heading as text. It does not move data or change a worksheet’s structure; it only returns a text result. If you need a cell reference for a later formula, be deliberate about whether you want text such as XL or an actual reference such as XL1, since those are different kinds of values in Excel.
Excel’s column limit and version context
In current Excel for Microsoft 365, a worksheet has 16,384 columns, ending at XFD. XL is well within that range, at position 636. The maximum row number is 1,048,576. These are worksheet grid limits, not limits on how many columns a table or chart can display at once.
The version matters if you are opening an old workbook. Excel 2007 and later use the 16,384-column grid. Excel 97–2003 worksheets stopped at column IV, which is column 256, so XL was beyond that older worksheet’s edge. A workbook saved in an older format can therefore behave differently from a modern .xlsx workbook. If you see compatibility warnings or a shortened grid, check the file format and the Excel version rather than assuming the letters have a different numeric meaning.
For column 636, there is no special setting to turn on: XL is a normal column in a modern worksheet. The limit becomes relevant when a formula or imported dataset refers to columns beyond the range supported by the workbook version, or when a calculation generates a number that does not correspond to a valid column.
When XL is a Roman numeral
Roman numerals use letters as symbols, and XL means 40 because a smaller numeral placed before a larger one is subtracted: L is 50 and X is 10, so XL is 50 − 10. That convention is different from Excel’s column numbering, where the same two letters identify column 636. A cell containing the text XL does not tell Excel by itself which interpretation you mean.
Excel’s ARABIC function converts a Roman numeral expressed as text to a number. With the Roman numeral XL in cell A2, enter =ARABIC(A2). The result is 40. If the numeral is typed directly into the formula, =ARABIC("XL") also returns 40. Excel’s ROMAN function performs the opposite conversion: with the number 40 in A2, =ROMAN(A2) returns the text XL.
These functions are for Roman-number conversion, not worksheet column references. In Microsoft 365, the formulas above are available; if a formula is not recognized in an older Excel installation, check that version’s function support. Also remember that a formula result formatted as text is not the same thing as the numeric value 40. Use ARABIC when later arithmetic needs the number, and ROMAN when a displayed Roman numeral is wanted.
Common mistakes and how to avoid them
- Confusing the two answers: XL is 636 as a column label and 40 as a Roman numeral. Use the surrounding context to choose the intended meaning.
- Adding letter positions instead of using place value: the calculation for XL is 24 × 26 + 12, not 24 + 12.
- Using a text label as though it were a cell reference: text in A2 that says XL is not automatically a reference to column XL. The INDIRECT example converts the text into a reference.
- Including a dollar sign or row number in the input: a value such as $XL$1 is a full reference, not just a column label. Keep the format consistent with the conversion formula you use.
- Exceeding the worksheet boundary: a number greater than 16,384 cannot identify a column in modern Excel, and older versions have a smaller limit.
- Expecting a display format to change the underlying value: formatting a cell to look like a Roman numeral does not convert a column label into a number. Use a conversion function when you need a calculated result.
Frequently Asked Questions
What is XL in Excel column numbers?
XL is column 636 in current versions of Excel. For a direct check, enter =COLUMN(XL1) in a worksheet cell; the row number in the reference does not change the result.
Is XL 40 or 636?
Both answers are correct in their own contexts. XL is 40 as a Roman numeral, but it is column 636 as an Excel column heading. The type of task—Roman numeral conversion or worksheet addressing—determines the answer.
How do I convert XL to 636 when XL is in a cell?
If A2 contains the text XL, use =COLUMN(INDIRECT(A2&"1")). It builds a reference to XL1 and returns the column position, 636. The cell must contain a valid column label.
How do I convert 636 to XL?
If A2 contains the number 636, use =SUBSTITUTE(ADDRESS(1,A2,4),"1",""). ADDRESS creates XL1 and SUBSTITUTE removes the row number, leaving XL.
How do I convert Roman numeral XL to a number in Excel?
Put XL in A2 and enter =ARABIC(A2) to get 40. Use this for Roman numerals, not for converting an Excel column label to its position.
Does XL exist as a column in every Excel version?
No. Modern Excel has columns through XFD, so XL exists. Excel 97–2003 ended at IV, so column 636 was outside that version’s worksheet grid.
Related
- US Number Format in Excel: Dates and Numbers
- Unmerge Shortcut in Excel: Windows Keys and Common Fixes
- University Budget Template in Excel: What to Include
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Not Responding? Causes, Fixes, and Recovery StepsIf Excel says “Not Responding,” wait briefly if it is calculating or opening a large file; if it…
- How to Shade a Cell in Excel With Two ColorsExcel does not have a built-in cell-fill option that divides one cell into two solid-color halves. For a…
- Microsoft Excel Heat Maps: How to Create and Read ThemA Microsoft Excel heat map uses cell colors to show the relative size or pattern of values in…
- How to Repair an Excel File in Windows 11To repair an Excel file in Windows 11, first make a copy of it, then open Excel and…
- How to Convert an Excel Workbook to Word DocumentsTo convert an Excel workbook to Word, choose what you need to preserve: copy a range as a…
- Google Sheets VLOOKUP: How to Find and Return DataGoogle Sheets VLOOKUP searches the first column of a range for a value and returns a value from…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.