Results 1 to 2 of 2
2007-03-17, 15:29 #1
- Join Date
- Dec 2000
- Sault Ste. Marie, Michigan, USA
- Thanked 0 Times in 0 Posts
Excel number formatting trick (2000 sr1)
If you've ever wanted to or had to duplicate a paper form in Excel you are probably aware of how frustrating Excel's number formatting is when the cell is too narrow to hold the number (#####). You then have to compromise the size of some columns or give up altogether.
Here is a formating trick I discovered using Center across Selection that makes paper form duplication a lot easier, the trick being to use a format with a "space" fill character on the left.
See some examples in the attached Workbook
2007-03-17, 15:57 #2
- Join Date
- Mar 2002
- Thanked 30 Times in 30 Posts
Re: Excel number formatting trick (2000 sr1)
Thanks for the tip! <img src=/S/thumbup.gif border=0 alt=thumbup width=15 height=15>
For others reading this: Center across Selection, as suggested by kjktoo, is much to be preferred above the Merge and Center option that is available on the Formatting toolbar. Merging cells causes all kinds of problems and is best avoided. Center across Selection leaves the individual cells intact, it only changes the display.