LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 293
Default Cell Text Alignment - Not A Centering Issue

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Text Alignment Ben Excel Discussion (Misc queries) 3 August 20th 07 07:48 PM
Issue with Cell alignment - need only the last line in cell to sho CamanoMouse New Users to Excel 1 May 23rd 07 11:13 AM
Text alignment dkingfish Excel Discussion (Misc queries) 0 January 22nd 07 03:44 PM
Cell compare has issue with MAJOR text Nfld Son Excel Discussion (Misc queries) 2 June 13th 06 04:35 PM
text alignment code k483 Excel Discussion (Misc queries) 1 July 12th 05 04:08 PM


All times are GMT +1. The time now is 06:40 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"