How do I keep the tab reference in my formulas when I'm editing? Some of my
cells contain the tab name and others do not. When I try to group and edit
worksheets, I get this odd R566,+C233 label in the remaining worksheets.

It's interesting to see the inners of excel, huh?

When you enter a formula, excel "sees/parses" it as R1C1 reference style--but it
displays the formula the way you want according to that setting.

Your problem is that in the other sheets, the cells are formatted as Text.
Change the format to General (or Number or whatever you want except Text) and
you'll be ok.

LeAnn wrote:

How do I keep the tab reference in my formulas when I'm editing? Some of my
cells contain the tab name and others do not. When I try to group and edit
worksheets, I get this odd R566,+C233 label in the remaining worksheets.

--

Dave Peterson

Thank you!!!!!

"Dave Peterson" wrote:

It's interesting to see the inners of excel, huh?

When you enter a formula, excel "sees/parses" it as R1C1 reference style--but it
displays the formula the way you want according to that setting.

Your problem is that in the other sheets, the cells are formatted as Text.
Change the format to General (or Number or whatever you want except Text) and
you'll be ok.

LeAnn wrote:

How do I keep the tab reference in my formulas when I'm editing? Some of my
cells contain the tab name and others do not. When I try to group and edit
worksheets, I get this odd R566,+C233 label in the remaining worksheets.

--

Dave Peterson

This worked the first time I did it but it's doing it again. I've formatted
my cells to be numbers and I'm still getting these references when I try to
group edit. Any other suggestions?

"LeAnn" wrote:

Thank you!!!!!

"Dave Peterson" wrote:

It's interesting to see the inners of excel, huh?

When you enter a formula, excel "sees/parses" it as R1C1 reference style--but it
displays the formula the way you want according to that setting.

Your problem is that in the other sheets, the cells are formatted as Text.
Change the format to General (or Number or whatever you want except Text) and
you'll be ok.

LeAnn wrote:

How do I keep the tab reference in my formulas when I'm editing? Some of my
cells contain the tab name and others do not. When I try to group and edit
worksheets, I get this odd R566,+C233 label in the remaining worksheets.

--

Dave Peterson

Excel likes to help and sometimes changes the format to text. -- cells that
contain formulas to cells with text can get changed.

Try formatting those cells as General one more time.

LeAnn wrote:

This worked the first time I did it but it's doing it again. I've formatted
my cells to be numbers and I'm still getting these references when I try to
group edit. Any other suggestions?

"LeAnn" wrote:

Thank you!!!!!

"Dave Peterson" wrote:

It's interesting to see the inners of excel, huh?

When you enter a formula, excel "sees/parses" it as R1C1 reference style--but it
displays the formula the way you want according to that setting.

Your problem is that in the other sheets, the cells are formatted as Text.
Change the format to General (or Number or whatever you want except Text) and
you'll be ok.

LeAnn wrote:

How do I keep the tab reference in my formulas when I'm editing? Some of my
cells contain the tab name and others do not. When I try to group and edit
worksheets, I get this odd R566,+C233 label in the remaining worksheets.

--

Dave Peterson


--

Dave Peterson