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