Strange cell addresses
 

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

Strange cell addresses
 

--
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.

"Robin Graham" wrote:

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
.

Strange cell addresses
 

Is DBG80 perhaps a definde name?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Robin Graham" wrote in message
...
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

Strange cell addresses
 

On 04/03/2010 19:52, Robin Graham wrote:
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

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