Text in Custom Number Formats
There are old posts in the newsgroups showing how to center align text
while right aligning numbers in a cell using the custom number format "* 0;* -0;* 0;@" and setting horizontal alignment to Centered. The '* ' piece can also be applied in the text portion of the format, e.g., "0;-0;0;* @" with General horizontal alignment would right align text. So what? Could just set horizontal alignment to Right. But in Excel 2007 and later number formats can be included in conditional formats but alignment can't, so this trick could be used to change text alignment in conditional formats. |
All times are GMT +1. The time now is 04:18 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com