Text Being Seen as Partial Cell Address
 

(I'm using MS Excel 2003 (11.8120.8122) SP2)

Please change the priority of Text Only to override the process by which
Excel flags cell addresses. True, "HP2" is a potential cell address, but
"CCC2-0307, HP2-0106" is not, especially if the cell is set for text only.
It is exasperating to have to change an entire database just because Excel
insists on reading text with potential cell addresses as actual partial
formulae.

Again, designating a cell/column/row/worksheet as Text should override any
automatic search by Excel for cell addresses. The other option is to be able
to disable this searching process in the Options menu.

--
Mike S.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

Text Being Seen as Partial Cell Address
 

You MIGHT change your A1 references to R1C1 in Excel (tools/options/general)
before opening the file -- then CCC2-0307 will NOT be thought of as a
reference.

"Mike S." wrote:

(I'm using MS Excel 2003 (11.8120.8122) SP2)

Please change the priority of Text Only to override the process by which
Excel flags cell addresses. True, "HP2" is a potential cell address, but
"CCC2-0307, HP2-0106" is not, especially if the cell is set for text only.
It is exasperating to have to change an entire database just because Excel
insists on reading text with potential cell addresses as actual partial
formulae.

Again, designating a cell/column/row/worksheet as Text should override any
automatic search by Excel for cell addresses. The other option is to be able
to disable this searching process in the Options menu.

--
Mike S.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

Text Being Seen as Partial Cell Address
 

It's not the CCC2 that's being seen as a reference, it's HP2. Still, I'll
try your suggestion.

--
Mike S.


"Bob Umlas, Excel MVP" wrote:

You MIGHT change your A1 references to R1C1 in Excel (tools/options/general)
before opening the file -- then CCC2-0307 will NOT be thought of as a
reference.

"Mike S." wrote:

(I'm using MS Excel 2003 (11.8120.8122) SP2)

Please change the priority of Text Only to override the process by which
Excel flags cell addresses. True, "HP2" is a potential cell address, but
"CCC2-0307, HP2-0106" is not, especially if the cell is set for text only.
It is exasperating to have to change an entire database just because Excel
insists on reading text with potential cell addresses as actual partial
formulae.

Again, designating a cell/column/row/worksheet as Text should override any
automatic search by Excel for cell addresses. The other option is to be able
to disable this searching process in the Options menu.

--
Mike S.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

Text Being Seen as Partial Cell Address
 

I just tried it, and it worked for 2 values "HP1" and "HP2". (I converted
the HP's to HMP.) But, "HP3" is still being seen as a cell reference. What
gives?

(And, yes, I've checked the help files, but they do not address this issue.
Also, all the listed help file entries show no "HP"s anywhere.)
--
Mike S.


"Bob Umlas, Excel MVP" wrote:

You MIGHT change your A1 references to R1C1 in Excel (tools/options/general)
before opening the file -- then CCC2-0307 will NOT be thought of as a
reference.

"Mike S." wrote:

(I'm using MS Excel 2003 (11.8120.8122) SP2)

Please change the priority of Text Only to override the process by which
Excel flags cell addresses. True, "HP2" is a potential cell address, but
"CCC2-0307, HP2-0106" is not, especially if the cell is set for text only.
It is exasperating to have to change an entire database just because Excel
insists on reading text with potential cell addresses as actual partial
formulae.

Again, designating a cell/column/row/worksheet as Text should override any
automatic search by Excel for cell addresses. The other option is to be able
to disable this searching process in the Options menu.

--
Mike S.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

Text Being Seen as Partial Cell Address
 

In light of my subsequent responses, I've since changed my database code from
"HP" to "HMP". This works, but the "HP3" issue still bothers me.

Do you have any idea why Excel see "HP3" as a partial formula? Or why
Excel's suggested help files do NOT display evidence of the "HP3"?

PS: Thanks for your input
--
Mike S.


"Bob Umlas, Excel MVP" wrote:

You MIGHT change your A1 references to R1C1 in Excel (tools/options/general)
before opening the file -- then CCC2-0307 will NOT be thought of as a
reference.

"Mike S." wrote:

(I'm using MS Excel 2003 (11.8120.8122) SP2)

Please change the priority of Text Only to override the process by which
Excel flags cell addresses. True, "HP2" is a potential cell address, but
"CCC2-0307, HP2-0106" is not, especially if the cell is set for text only.
It is exasperating to have to change an entire database just because Excel
insists on reading text with potential cell addresses as actual partial
formulae.

Again, designating a cell/column/row/worksheet as Text should override any
automatic search by Excel for cell addresses. The other option is to be able
to disable this searching process in the Options menu.

--
Mike S.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc