formulas showing not value
 

why is it that if a reference a cell e.g =A1 then it actually shows that
text not whats in A1 ?????
And this is only happening to a few of my cells ??


--
Zygan
------------------------------------------------------------------------
Zygan's Profile: http://www.excelforum.com/member.php...o&userid=34423
View this thread: http://www.excelforum.com/showthread...hreadid=554461

formulas showing not value
 

Nel post
*Zygan* ha scritto:

why is it that if a reference a cell e.g =A1 then it actually shows
that text not whats in A1 ?????
And this is only happening to a few of my cells ??


Could you please explain better which is your problem?

--
Ciao

Franz Verga from Italy

formulas showing not value
 

Hi Zygan,
Maybe the cells was formated as Text when you wrote the cell reference.
Try to delete the contents and format the cell as Generel.
Right Click - Format Cells - Number and chose Generel

Regards,
Bondi

formulas showing not value
 

Excel likes to help.

Try this on a test worksheet.
Select A1 and hit ctrl-; (to put the date in the cell)
now select B1 and type: =a1

Notice that excel changed the format of B1 to match the format in A1.

Now format D1 as Text.
put ASDF in D1
put =D1 in E1
You see ASDF.

With E1 selected, hit the F2 key and then enter (to pretend that you're changing
the formula).

Excel has "helped" you by changing that cell's format to text.

I don't know of any way of changing this behavior.

I just select the cell, and reformat it to General (or whatever I wanted). I
hit F2 and then enter (to reenter that formula).

Sometimes this feature is nice, sometimes it ain't.

Zygan wrote:

why is it that if a reference a cell e.g =A1 then it actually shows that
text not whats in A1 ?????
And this is only happening to a few of my cells ??

--
Zygan
------------------------------------------------------------------------
Zygan's Profile: http://www.excelforum.com/member.php...o&userid=34423
View this thread: http://www.excelforum.com/showthread...hreadid=554461

--

Dave Peterson