| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Alignment: Center text but Right numbers.
I have an equation in B16 which, if B10 has a valid entry, will bring in a
factor. This factor should be aligned to the Right, or General (as numbers align to the right automatically). However, if B10 is invalid, my B16 formula puts text in B16, and I would like that Centered. I cannot find a way to Center under Conditional Formatting, but I am wondering if there is a different way to Center when the text is there? Using Excel 2007 -- Brad E. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| center text | Excel Discussion (Misc queries) | |||
| What is the default alignment style for numbers? | Excel Discussion (Misc queries) | |||
| Changing Selection for the "Center Across Selection" alignment | Excel Discussion (Misc queries) | |||
| can't change the alignment of numbers in cells | Excel Discussion (Misc queries) | |||
| numbers in the center of the page? | Excel Discussion (Misc queries) | |||
Threaded Mode
