Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Text Alignment | Excel Discussion (Misc queries) | |||
Issue with Cell alignment - need only the last line in cell to sho | New Users to Excel | |||
Text alignment | Excel Discussion (Misc queries) | |||
Cell compare has issue with MAJOR text | Excel Discussion (Misc queries) | |||
text alignment code | Excel Discussion (Misc queries) |