Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 . |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Strange Cell Format Behavior | Excel Discussion (Misc queries) | |||
formula looks strange in excel cell | Excel Discussion (Misc queries) | |||
Strange looking cell in Excel | Excel Discussion (Misc queries) | |||
Strange looking cell in Excel sheet | Excel Discussion (Misc queries) | |||
entering a26-02 into a cell give strange result | Excel Discussion (Misc queries) |