How to Flip Numbers Upside Down in Excel: Two Methods

To turn numbers visually upside down in Excel, put them in a text box and rotate the box 180 degrees; this preserves their appearance as a rotated object, not as a cell value. If you need upside-down-looking characters in cells, use a formula that reverses the digits and substitutes approximate Unicode characters instead. Choose the text box for a true visual rotation, or the formula when you need a result you can copy as text.

What You’ll Need

Excel for Microsoft 365 on Windows for the steps below. The text-box method is also available in Excel for Mac, although ribbon labels or their locations may vary slightly.
A number to display. For the formula method, use a positive whole number; the formula below is designed for digits only, not decimals or formatted values.
For formula results, a font that displays the Unicode characters used in the example. Their shapes are approximations, and appearance can differ by font and device.
If you plan to print or share the workbook, check the result in the intended destination. A floating text box and Unicode glyphs may not look identical in every app or font.

Step-by-Step

Decide whether you need rotation or transformed text. A cell in Excel cannot rotate its contents a full 180 degrees with the usual text-orientation controls. A rotated text box is the best option when the number must genuinely appear upside down on the sheet. A formula is useful when you want a new string in a cell, but the output uses look-alike characters rather than a mathematically rotated number. Neither choice changes a numeric value into another numeric value.
For a genuine visual rotation, insert a text box. Select the worksheet where you want the display. On the Windows ribbon, choose Insert > Text Box, then click and drag on the sheet to draw the box. Type the number into it. If the number is already in a cell, copy it and paste it into the text box; alternatively, type it again. The box is a separate floating object, so it does not automatically become the cell’s contents.
Size and position the box before rotating. Click the box border, not inside the text, and drag its handles until the number fits. Use the rotation handle above the box to turn it by hand if you can judge the angle, or use the ribbon for a precise half-turn. Selecting the border matters: clicking the text itself puts you in text-editing mode, where rotation controls may not be available.
Rotate the text box by 180 degrees. With the box selected, open the contextual Shape Format tab, choose Rotate, then choose Rotate Right 90° twice. Each selection turns the object another quarter-turn, producing a half-turn. The text rotates with its box. The same approach works in Excel for Mac, though the contextual tab or Rotate menu may be named or arranged differently. Excel for the web may offer a different set of shape controls; if you do not see the rotation choices, use the desktop app.
Make the text box blend into the worksheet if needed. Keep the box selected and use the shape formatting controls to set its fill to No Fill and its outline to No Outline. These options are useful when you want only the upside-down number to show. If you want a visible label or sign, leave the border or fill in place. Resize the box again if the rotated text clips or sits too close to an edge.
For upside-down-looking characters in a cell, prepare a source value. Put a positive whole number in A1. If leading zeros matter, enter the value as text so Excel does not remove them; you can start the entry with an apostrophe, such as '0123. A numeric cell stores a number, while a text entry preserves the exact characters you typed. This distinction matters because the formula reads characters, not number formatting.
Enter a character-conversion formula in another cell. With the source number or digit string in A1, enter this formula in B1. It reads the characters from right to left and substitutes commonly used upside-down-looking Unicode glyphs for digits 1 through 9; 0 remains 0.

=TEXTJOIN("",TRUE,MAP(MID(A1,SEQUENCE(LEN(A1),,LEN(A1),-1),1),LAMBDA(d,SWITCH(d,"0","0","1","Ɩ","2","ᄅ","3","Ɛ","4","h","5","Ƽ","6","9","7","L","8","8","9","6",d))))

For example, if A1 contains 123, B1 displays ƐᄅƖ. Read the result as a visual approximation, not as a standard rotated font or a numeric answer. The formula uses MAP and LAMBDA, which are available in Microsoft 365 and Excel 2024; it may not work in older Excel versions. If Excel reports an unknown function, use the text-box method or enter a short result manually with suitable characters.

Check and use the result appropriately. Confirm that B1 shows all the expected characters and that the font renders them. If you need a fixed piece of text rather than a formula linked to A1, copy B1 and use Home > Paste > Values where available, or use the paste options to paste values. On Windows, Ctrl+C copies and Ctrl+V pastes; on Mac, use Command+C and Command+V. The formula output is text and cannot be used as the original numeric value in calculations.

Common Mistakes

Expecting cell orientation to turn text upside down. Excel’s cell alignment orientation tools do not provide a full 180-degree rotation. They can angle text or display it vertically, but those settings are not the same as turning a number upside down. Use a rotated shape for a true rotation.

Rotating the wrong thing. The text box must be selected as an object before you open Shape Format. If you can see a text cursor inside the box, click its border to select the whole shape. Otherwise, you may only edit the text and not see the shape rotation controls.

Assuming the formula produces a real rotated numeral. Unicode characters such as Ɛ and ᄅ are visual stand-ins. They can resemble turned digits, but they are not a guaranteed match for the exact outlines of the original font. If exact typography matters, rotate a shape or create a graphic in an application with the required font controls.

Using the formula on decimals, signs, or formatted numbers. The example is intended for positive whole-number characters. It does not transform punctuation, minus signs, currency symbols, or thousands separators into proper upside-down equivalents. Also, cell formatting such as displaying 1,000 does not necessarily mean those commas are part of the underlying value that the formula reads.

Expecting the result to remain numeric. A formula that returns Unicode glyphs returns text. Do not use that display string for sums, sorting as numbers, or numeric comparisons. Keep the original number in a separate cell for calculations.

Tips

Keep the original number in a normal cell and use a separate text box or output cell for the display. This makes it easier to update the source, run calculations, and explain which item is the actual value. If you use the shape, you can place it beside the source cell and resize or reposition it without changing the worksheet’s calculations.

For signs, headings, or a small number of labels, the text-box method is usually the clearest and most dependable. It rotates the whole string as one object, including its spacing, and avoids relying on substitute characters. For repeated data, the formula can create cell text automatically when A1 changes, but check several representative outputs before filling it down a list.

If the displayed result must be readable on different computers, test the workbook using the likely font and viewing software. Unicode glyphs may be substituted if a font lacks them. Shapes are generally a better choice for a precise visual effect, but a shape can move independently of cells when rows or columns are resized. Consider setting the shape’s placement behavior in its formatting options if alignment with cells is important.

For an easy-to-read result, use a sufficiently large font and leave white space around a rotated box. A box that fits before rotation may look cramped afterward, so check all four sides and adjust its dimensions. If the number is part of a printed page, use Print Preview to check its position and orientation before printing.

Troubleshooting

The Rotate command is missing. Click the text box’s outer border to select the shape, then look for the contextual Shape Format tab. If you are editing the text, press Esc once and click the border. In Excel for the web, shape commands may be limited; open the workbook in desktop Excel if you cannot find the needed rotation options.

The text box turns but the letters do not. Make sure you rotated the text box object, not a separate border or another shape. A normal text box rotates its text along with the box. If the number was entered in a worksheet cell behind the box, that cell will stay unchanged; the visible rotated copy is the text box content.

The formula returns an error. Check that A1 is not blank and that your Excel version supports MAP and LAMBDA. Those functions require Microsoft 365 or Excel 2024. Also check for a typo in the formula, especially paired quotation marks and parentheses. If your Excel installation uses a different list separator, it may expect semicolons rather than commas; the formula here uses the standard comma syntax for Microsoft 365 on Windows.

Some characters look like boxes or ordinary digits. Try a different font that supports the Unicode characters, or use a text box rotated 180 degrees for a consistent result. The substitute glyph for a digit is not guaranteed to look the same in every font. If you share the workbook, check it on the recipient’s device too.

The formula drops a leading zero or does not include displayed separators. Enter the source as text if every digit, including a leading zero, must be preserved. Excel formulas read the stored value rather than necessarily copying the cell’s number format. For special formatting such as commas or decimal places, first decide which exact characters you want to reverse, then store that exact string as text; the supplied formula is not a general-purpose number-format converter.

Frequently Asked Questions

Can I rotate numbers in an Excel cell by 180 degrees?

Not with the standard cell text-orientation controls. Use a text box or another shape and rotate it by 90 degrees twice. The rotated object is separate from the cell’s stored value.

Does the Unicode formula work with any number?

It is intended for positive whole numbers made of digits. It reverses the characters and substitutes approximate glyphs. Decimal points, signs, spaces, and separators are not properly converted, so use a rotated text box for those cases.

Will an upside-down number still calculate in Excel?

A rotated text box is a visual object and does not replace the cell value. The Unicode formula returns text, not a number. Keep the original numeric value in a separate cell for calculations.

Why does 6 become 9 and 9 become 6?

Those digits have familiar counterparts when turned upside down, so the formula maps 6 to 9 and 9 to 6. Other mappings are approximations based on particular Unicode characters, and their appearance depends on the font.

Can I use the formula in an older version of Excel?

The formula shown uses MAP and LAMBDA, which require Microsoft 365 or Excel 2024. For an older version, use a rotated text box, or manually enter the transformed characters for a short label.

Can I flip the number upside down and keep it editable?

You can edit text inside a rotated text box, but it remains a floating shape rather than a cell value. The formula result updates from its source cell, but it is editable as a formula or source string rather than as a numeric result. Choose based on whether visual placement or spreadsheet calculations matter more.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.