Greetings,

I have two cells next to each other at H4 & I4. H4 has been formatted
Right indent and I4 Left indent. They are the two parts to a single
number. H4 is the whole number portion and I4 is the decimal portion.
Each is fed from an Offset formula. If I format H4 as "Centered
Across Selection" in the formatting menu, I see the correct results.
However that format looks strange in this instance.

Problem: H4 shows nothing and I4 shows the decimal (as it is supposed
to). Example: H4 = "1234" and I4 = ".06" (I4 is formatted as the
number format - ".00" without a leading) with the proper formatting it
should look like "1234.06" without actually being one number. What I
am getting is " .06". The whole number is the customers ID number
and the decimal is the changes to that customers record.

Any one have any ideas as what would cause H4 not to show anything?

Any help, suggestions or links would be appreciated.

Thanks for looking at my problem and any assistance you may be able
and willing to offer.

-Minitman

hi
after reading your post, i would suspect that the offset formula is picking
up the wrong value. but without seeing your data and formulas, that is just a
wild guess at this point.

Regards
FSt1

"Minitman" wrote:

Greetings,

I have two cells next to each other at H4 & I4. H4 has been formatted
Right indent and I4 Left indent. They are the two parts to a single
number. H4 is the whole number portion and I4 is the decimal portion.
Each is fed from an Offset formula. If I format H4 as "Centered
Across Selection" in the formatting menu, I see the correct results.
However that format looks strange in this instance.

Problem: H4 shows nothing and I4 shows the decimal (as it is supposed
to). Example: H4 = "1234" and I4 = ".06" (I4 is formatted as the
number format - ".00" without a leading) with the proper formatting it
should look like "1234.06" without actually being one number. What I
am getting is " .06". The whole number is the customers ID number
and the decimal is the changes to that customers record.

Any one have any ideas as what would cause H4 not to show anything?

Any help, suggestions or links would be appreciated.

Thanks for looking at my problem and any assistance you may be able
and willing to offer.

-Minitman

Hey FSt1,

Thanks for the reply.

One thing that I did not mention is that all of the cells in the form
are named ranges from pfCell_1 the pfCell_80 for ease in looping data
in and out of this form. I did not mention it because I did not think
it was relevant.

The formula in cell pfCell_5 is:

=IF(OFFSET(clStart,pfDisc,4)=0,"",OFFSET(clStart,p fDisc,4))

The formula in cell pfCell_6 is:

=IF(OFFSET(clStart,pfDisc,5)=0,"",OFFSET(clStart,p fDisc,5))

clStart is CustInfo!A1 on the data sheet called CustInfo, pfDisc is
the number of the row for the chosen record on that CustInfo worksheet
and 4 and 5 are the number of columns from column A that the requested
data is sitting.

There are 80 such formulas in this form. All but these two and four
memo fields are aligned as "Centered Across Selection".

The data in a test record located in the 5th column of the source
worksheet = 1234 and the data in the 6th column of the same test
record = .06.

If I move pfCell_5 to the left side of the area reserved for that
entry and realign as "Centered Across Selection", it displays as
expected. It just doesn't line up with pfCell_6, which is why I am
asking this question.

-Minitman


On Sun, 13 Jul 2008 04:36:02 -0700, FSt1
wrote:

hi
after reading your post, i would suspect that the offset formula is picking
up the wrong value. but without seeing your data and formulas, that is just a
wild guess at this point.

Regards
FSt1

"Minitman" wrote:

Greetings,

I have two cells next to each other at H4 & I4. H4 has been formatted
Right indent and I4 Left indent. They are the two parts to a single
number. H4 is the whole number portion and I4 is the decimal portion.
Each is fed from an Offset formula. If I format H4 as "Centered
Across Selection" in the formatting menu, I see the correct results.
However that format looks strange in this instance.

Problem: H4 shows nothing and I4 shows the decimal (as it is supposed
to). Example: H4 = "1234" and I4 = ".06" (I4 is formatted as the
number format - ".00" without a leading) with the proper formatting it
should look like "1234.06" without actually being one number. What I
am getting is " .06". The whole number is the customers ID number
and the decimal is the changes to that customers record.

Any one have any ideas as what would cause H4 not to show anything?

Any help, suggestions or links would be appreciated.

Thanks for looking at my problem and any assistance you may be able
and willing to offer.

-Minitman

hi
allignment should have no effect on the offset return. are you using merged
cells?

regards
FSt1

"Minitman" wrote:

Hey FSt1,

Thanks for the reply.

One thing that I did not mention is that all of the cells in the form
are named ranges from pfCell_1 the pfCell_80 for ease in looping data
in and out of this form. I did not mention it because I did not think
it was relevant.

The formula in cell pfCell_5 is:

=IF(OFFSET(clStart,pfDisc,4)=0,"",OFFSET(clStart,p fDisc,4))

The formula in cell pfCell_6 is:

=IF(OFFSET(clStart,pfDisc,5)=0,"",OFFSET(clStart,p fDisc,5))

clStart is CustInfo!A1 on the data sheet called CustInfo, pfDisc is
the number of the row for the chosen record on that CustInfo worksheet
and 4 and 5 are the number of columns from column A that the requested
data is sitting.

There are 80 such formulas in this form. All but these two and four
memo fields are aligned as "Centered Across Selection".

The data in a test record located in the 5th column of the source
worksheet = 1234 and the data in the 6th column of the same test
record = .06.

If I move pfCell_5 to the left side of the area reserved for that
entry and realign as "Centered Across Selection", it displays as
expected. It just doesn't line up with pfCell_6, which is why I am
asking this question.

-Minitman


On Sun, 13 Jul 2008 04:36:02 -0700, FSt1
wrote:

hi
after reading your post, i would suspect that the offset formula is picking
up the wrong value. but without seeing your data and formulas, that is just a
wild guess at this point.

Regards
FSt1

"Minitman" wrote:

Greetings,

I have two cells next to each other at H4 & I4. H4 has been formatted
Right indent and I4 Left indent. They are the two parts to a single
number. H4 is the whole number portion and I4 is the decimal portion.
Each is fed from an Offset formula. If I format H4 as "Centered
Across Selection" in the formatting menu, I see the correct results.
However that format looks strange in this instance.

Problem: H4 shows nothing and I4 shows the decimal (as it is supposed
to). Example: H4 = "1234" and I4 = ".06" (I4 is formatted as the
number format - ".00" without a leading) with the proper formatting it
should look like "1234.06" without actually being one number. What I
am getting is " .06". The whole number is the customers ID number
and the decimal is the changes to that customers record.

Any one have any ideas as what would cause H4 not to show anything?

Any help, suggestions or links would be appreciated.

Thanks for looking at my problem and any assistance you may be able
and willing to offer.

-Minitman

Hey FSt1

Problem fixed!

Thanks for trying, but this was a machine problem, I was getting
suspicious when other little quirks started to appear so I thought
maybe it was time to reboot and that cleared up the problem.

Again thanks for looking at this issue.

-Minitman


On Sun, 13 Jul 2008 07:01:01 -0700, FSt1
wrote:

hi
allignment should have no effect on the offset return. are you using merged
cells?

regards
FSt1

"Minitman" wrote:

Hey FSt1,

Thanks for the reply.

One thing that I did not mention is that all of the cells in the form
are named ranges from pfCell_1 the pfCell_80 for ease in looping data
in and out of this form. I did not mention it because I did not think
it was relevant.

The formula in cell pfCell_5 is:

=IF(OFFSET(clStart,pfDisc,4)=0,"",OFFSET(clStart,p fDisc,4))

The formula in cell pfCell_6 is:

=IF(OFFSET(clStart,pfDisc,5)=0,"",OFFSET(clStart,p fDisc,5))

clStart is CustInfo!A1 on the data sheet called CustInfo, pfDisc is
the number of the row for the chosen record on that CustInfo worksheet
and 4 and 5 are the number of columns from column A that the requested
data is sitting.

There are 80 such formulas in this form. All but these two and four
memo fields are aligned as "Centered Across Selection".

The data in a test record located in the 5th column of the source
worksheet = 1234 and the data in the 6th column of the same test
record = .06.

If I move pfCell_5 to the left side of the area reserved for that
entry and realign as "Centered Across Selection", it displays as
expected. It just doesn't line up with pfCell_6, which is why I am
asking this question.

-Minitman


On Sun, 13 Jul 2008 04:36:02 -0700, FSt1
wrote:

hi
after reading your post, i would suspect that the offset formula is picking
up the wrong value. but without seeing your data and formulas, that is just a
wild guess at this point.

Regards
FSt1

"Minitman" wrote:

Greetings,

I have two cells next to each other at H4 & I4. H4 has been formatted
Right indent and I4 Left indent. They are the two parts to a single
number. H4 is the whole number portion and I4 is the decimal portion.
Each is fed from an Offset formula. If I format H4 as "Centered
Across Selection" in the formatting menu, I see the correct results.
However that format looks strange in this instance.

Problem: H4 shows nothing and I4 shows the decimal (as it is supposed
to). Example: H4 = "1234" and I4 = ".06" (I4 is formatted as the
number format - ".00" without a leading) with the proper formatting it
should look like "1234.06" without actually being one number. What I
am getting is " .06". The whole number is the customers ID number
and the decimal is the changes to that customers record.

Any one have any ideas as what would cause H4 not to show anything?

Any help, suggestions or links would be appreciated.

Thanks for looking at my problem and any assistance you may be able
and willing to offer.

-Minitman