The direct answer: there is no built-in Excel function called “ARCADE” for converting numbers to text. If you mean converting a number to a string in Excel, use the TEXT function (e.g., =TEXT(A1,"0")) or the & concatenation operator (e.g., =A1&""). If you are working with a game or arcade machine’s data, the conversion method depends on the programming language, but in Excel, these are the standard approaches.
What Does “Arcade Number to String” Actually Mean?
The phrase “arcade number to string” is ambiguous. It could refer to:
- Converting a numeric score (like 1250) into a text string in a spreadsheet for display or concatenation.
- Converting a number stored in an arcade machine’s memory (e.g., a binary value) into a readable string in a data export.
- A mistyped search for “Excel number to string” or “Arduino number to string” (since Arduino is used in arcade builds).
In the context of Excel, the most common need is turning a number into text so it can be combined with other text, formatted with leading zeros, or used in a lookup. This article focuses on Excel solutions, with notes for other contexts.
How to Convert a Number to String in Excel
Excel has several ways to convert a number to a string. The simplest is to use the TEXT function, which converts a number to text with a specified format. For example, with the number 1234 in cell A1:
=TEXT(A1,"0")returns “1234” as text.=TEXT(A1,"00000")returns “01234” (leading zeros).=TEXT(A1,"#,##0")returns “1,234” with a comma separator.
Alternatively, you can force a number to text by concatenating it with an empty string: =A1&"". This is a quick trick that works in any Excel version.
Another method is to use the VALUE function in reverse? No—VALUE converts text to number. To convert a number to text, you can also use CONCATENATE or the & operator: =CONCATENATE(A1) or =A1&"".
Using the TEXT Function for Formatting
The TEXT function is the most flexible because it lets you control the exact appearance of the string. It follows the syntax TEXT(value, format_text). The format_text argument uses the same format codes as custom number formats. For example:
=TEXT(A1,"0.00")→ “1234.00”=TEXT(A1,"General")→ “1234” (as text)=TEXT(A1,"dd/mm/yyyy")→ converts a date serial number to a date string.
This is especially useful when you need to embed numbers in a sentence. For instance, with a score in A1, ="Your score is "&TEXT(A1,"0")&" points" returns “Your score is 1234 points” as a text string.
Note: The TEXT function always returns a text string, even if the result looks like a number. This can affect calculations, so use it only when you need text output.
Common Problems and Misconceptions
One common issue is that after converting a number to text, you cannot use it in arithmetic without converting back with VALUE. For example, =TEXT(A1,"0")+1 will result in a #VALUE! error because Excel cannot add a text string and a number. To avoid this, keep the original number in a separate cell.
Another misconception is that changing the cell format to Text will convert the number. Formatting a cell as Text before entering a number stores it as text, but formatting an existing number as Text does not change its data type—it only changes how it displays. To truly convert, you must use a formula or the Text to Columns feature (Data > Data Tools > Text to Columns, then choose “Text” as the column data format).
Also, be aware of the NUMBERVALUE function, which converts text to a number in a locale-independent way, but there is no “NUMBERTOSTRING” function—use TEXT.
Excel vs. Google Sheets vs. Other Tools
In Google Sheets, the same functions work: TEXT and & are available. However, the format codes are slightly different for dates and locales. For example, in Excel, =TEXT(A1,"mm/dd/yyyy") works, but in Google Sheets, you might need =TEXT(A1,"MM/DD/YYYY") (uppercase MM for months).
In programming languages like Python or JavaScript, the conversion is different: Python uses str(number), JavaScript uses Number.toString(). If you are pulling data from an arcade machine into Excel, you might need to use Power Query (Get & Transform Data) to import and convert the data. In Power Query, you can change a column’s data type to Text using the UI or the Table.TransformColumnTypes function.
How to Choose the Right Method
Choose the method based on your goal:
- If you need a specific format (leading zeros, decimal places), use
TEXT. - If you just need to combine with other text, use
&with an empty string. - If you want to permanently store the number as text (e.g., for a CSV export), use the Text to Columns feature or format the cell as Text before entering data.
- If you are working with a large dataset, consider using Power Query to convert data types during import.
For a quick one-off, =A1&"" is the simplest. For a repeatable and readable formula, =TEXT(A1,"0") is clearer.
Safety and Accuracy Tips
When converting numbers to text, be careful with leading zeros. If you use =A1&"" on a number like 00123, Excel will first convert the number to 123 (since it doesn’t store leading zeros), so the result will be “123”. To preserve leading zeros, you must enter the value as text from the start or use TEXT with the appropriate format.
Also, be aware of locale differences: in some European countries, the decimal separator is a comma, so =TEXT(A1,"0,00") may be needed. The TEXT function uses the system’s locale by default, but you can override with a locale code in the format (e.g., =TEXT(A1,"0.00","en-US") is not valid—instead, use the NUMBERVALUE function for conversions).
Always test your formulas with sample data to ensure the output matches expectations, especially when using custom formats.
Frequently Asked Questions
How do I convert a number to a string without losing leading zeros?
Use the TEXT function with a format that includes the zeros, like =TEXT(A1,"00000"). This will convert the number 123 to the text “00123”. Alternatively, enter the value as text by typing an apostrophe before it (e.g., ‘00123) in the cell.
Can I convert a whole column of numbers to text at once?
Yes, select the column, go to Data > Text to Columns, choose “Delimited” or “Fixed width” (just click Next), then in step 3 choose “Text” as the column data format and click Finish. This converts all selected cells to text. Alternatively, use a helper column with a formula like =A1&"" and then copy-paste values.
Why does my TEXT formula return a #VALUE! error?
This error usually occurs if the format_text argument is not a valid format code or if the value is not a number. Check that the format code is enclosed in quotes and that the value is numeric. For example, =TEXT(A1,"0") works, but =TEXT(A1,0) fails because 0 is not a text string.
Is there a difference between TEXT and CONCATENATE?
Yes, TEXT converts a number to a formatted string, while CONCATENATE joins multiple strings together. To convert a number to text and concatenate, you can combine them: =CONCATENATE("Score: ",TEXT(A1,"0")) or simply ="Score: "&TEXT(A1,"0").
How do I convert a string back to a number in Excel?
Use the VALUE function, e.g., =VALUE("123") returns 123. You can also multiply by 1 (="123"*1) or use the double unary operator (--"123"). For more complex conversions, use NUMBERVALUE which handles locale-specific separators.
Related
- Split a String in BigQuery? SQL Methods
- Cell Counting Protocol: Step-by-Step Guide
- Minimize Window Shortcut: Windows & Mac Keys
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel Formula for Weeks Between Two Dates: Full WeeksTo calculate weeks between two dates in Excel, subtract the start date from the end date and divide…
- Python split() Function: How It Works with ExamplesThe split() method in Python divides a string into a list of substrings based on a specified separator,…
- SUMIFS Between Two Dates in Excel: Formula & ExamplesTo sum values whose dates fall between two dates in Excel, use SUMIFS with the date column as…
- Project Budget Tracker Spreadsheet: Setup and FormulasA project budget tracker spreadsheet compares the approved budget with actual spending and outstanding commitments, so you can…
- Excel Formula Bar Not Showing Text? Fixes That WorkIf Excel’s formula bar is missing, turn it back on with View > Show > Formula Bar in…
- Excel Formula to Concatenate Names: Examples and TipsTo concatenate first and last names in Excel, use =A2&" "&B2 when the first name is in A2…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.