Strange cell addresses

R

Robin Graham

I copied and pasted a profit and loss account from Word to Excel. I now
find that some of the cells have addresses such as DBG80. This address
is found in B15. But it is only apparent when I perform some action such
as =, then click in the cell to put its address in the bar to start
setting up a calculation. Although I end up with the correct answer,
what's going on?

Rob Graham
 
G

Gary''s Student

--
Gary''s Student - gsnu201001
If you are using 2007, the cell address is legal. If you are not using
2007, it is probably a Defined Name.
 
R

Robin Graham

I copied and pasted a profit and loss account from Word to Excel. I now
find that some of the cells have addresses such as DBG80. This address
is found in B15. But it is only apparent when I perform some action such
as =, then click in the cell to put its address in the bar to start
setting up a calculation. Although I end up with the correct answer,
what's going on?

Rob Graham
Click to expand...

Right. Thanks. Why would this occur on a paste from Word? BTW I'm using
Office 2000.
 
Top