Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do I assign a cell equal to another cell
Hai , I facing a problem in Office 2003 , when I pres = then go to the cell
that I want , it will come out a formula , anyway to let it come out as cell name (ie =D5 at D20 cell) Thanks |
#2
|
|||
|
|||
Hi
try tools / options / view and untick formulas the other option is that your cells have been formatted as text select a blank cell in a new worksheet / workbook and copy it select the misbehaving cells and choose edit / paste special - add cheres JulieD "yl" wrote in message ... Hai , I facing a problem in Office 2003 , when I pres = then go to the cell that I want , it will come out a formula , anyway to let it come out as cell name (ie =D5 at D20 cell) Thanks |
#3
|
|||
|
|||
Maybe a bit more detail will help.
"yl" wrote: Hai , I facing a problem in Office 2003 , when I pres = then go to the cell that I want , it will come out a formula , If you press =, then you are entering a formula. anyway to let it come out as cell name (ie =D5 at D20 cell) If you want an = sign in a cell(?), you can insert it by pressing '=, to enter it as text. So if you type '=D5 in D20, it will show =D5. If you are in cell D20, and you want it to be equal to the value of D5, you are doing the right thing. Press = and then click on D5. D20 will then show the value of D5. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make a cell equal to another cells value and not it's fo. | Excel Worksheet Functions | |||
make cell contents equal to null value - not blank, but empty | Excel Worksheet Functions | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
GET.CELL | Excel Worksheet Functions |