is it possible to add numbers to a cell that contains text in Excel 2003?

Question

It is a 10 x 10 grid spreadsheet for a football pool. the squares have names in them, but wanted to number them in top left-hand or right-hand corner

i would like to have each of the 100 hundred cells numbered. The are to be smaller, similar to a trademark, than the text and located in top left or right corner of each cell

Answer 1

To raise number to upper left hand corner:
Select Cell..
Key F2 to edit.
Enter Number before Name.
Select Number and format as a SuperScript.
---
To raise number to upper right hand corner.
Follow same instructions, but Enter number after 'Name'
---
Alternate Methods:

Enter Number and use Ctrl-Enter to insert Carriage Return and move name down a line.

or

Go the End of the Name
Use Ctrl-Enter to insert Carrage Return
and Type in Number on this second line.

Answer 2

A super or sub script formatting of a portion of the text might work. What I would do is create the grid with 4 cells each. I would merge the top upper cells and place the name here. In the lower right or left corner I would put a value for the winner of that cell. I would designate a cell/cells that will contain the winning value. In the remainder of the empty cells I would paste the formula.

=if($a$1=b1,"Winner","")

Where $a$1 is the designated winning value and b1 changes to each blank cell that you have. Don't remove the $ signs.

God Bless

Frank Pytel

Answer 3

To designate a cell as text in Excel, put a single quote before the text. For example, '1. team x would come out as 1. team x. Excel will get rid of the single quote. Hope this helps...

Answer 4

If the text fabric is in columns A & B and column C is empty in cellular C1 Create the formula =A1&"."&B1 replace the truthfully row you're on, in the formula reproduction the formula down as many rows as necessary spotlight all of the formula decide on reproduction then Paste particular decide for values this could convert the formula's it is likewise possible to paste them over column A in case you want to characteristic text fabric to a column you probably can use the above approach. place an & in front of the text fabric and enclose it in " " marks. occasion in column C =A1&" this text would be appended" in case you want to apply Jeni's approach i could insert a column between the two you want to merge and fill it with a dot in each row. that would save enhancing each row after the merge. Jeni's approach has the excellent element approximately no longer needing extra columns, however the drawback of only working with one row at a time.

Answer 5

Click in the cells and add the numbers that you want.

You can right click the row or column and choose insert - that will add an additional row or column where you can put the outside numbers.

Answer 6

You should be able to put numbers in but of course they will still be 'text' not actual numbers.