![]() ![]() Let’s delete the cell B4 and return the formatting to ‘General’. And this one works perfectly well with both – texts and numbers. The Second Way – How to Write the Squared Symbol in Excel with Numbersīut this is not necessary, because there’s one more way to insert the squared symbol in a cell. If you need to make a quick fix, you need to change the cell formatting to ‘Text’. So, if the cell is formatted as ‘General’ or ‘Number’, you’ll simply have to use the way we’re about to have a look at. Unfortunately, to write the squared symbol the way we just did doesn’t work with numbers. You’ll see this window where you’ll find the Effects section and tick ‘Superscript’. We can simply type in the cell ‘m2’ and format the number 2 to display correctly.įirst, we need to select the number 2 written within the text, then we go to the Home tab and click here, on the bottom right-hand corner, to open ‘Font Settings’. Let’s say we want to type the sign for the square metre. The first way to write the squared symbol relies on the use of formatting. 2 The Second Way – How to Write the Squared Symbol in Excel with Numbers The First Way – How to Write the Squared Symbol in Excel within Text
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |