Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
stevjones
 
Posts: n/a
Default how do I eliminate proportional spacing in Excel spreadsheets?

Arial in Excell 2000 was NOT proportional spaced. I have just converted to
Excel 2003, where Arial (and just about every other type, too!) IS
proportionally spaced. With proportional spacing, numbers in a column do not
line up due to different spacing---particularly numbers like 111,111 versus
999,999. This is driving me crazy. Can anyone help? Thanks.
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

First, Arial is a proprotionally spaced font.

If you change the zoom factor to 100% does it look ok?

If yes, then maybe this post by Debra Dalgleish will help:

You can change a registry setting to prevent this from happening (make a
backup copy of the registry first):

1. From the Start button, choose Run
2. Type regedit then click OK
3. Click the + sign to the left of HKEY_CURRENT_USER
4. Open Software, Microsoft, Office, 9.0, Excel, Options
5. Choose EditNewDWORD Value
6. Type the name for the DWORD: FontSub
7. Press Enter to complete the renaming
8. Choose EditModify
9. Type 0 as the value, select Decimal, and click OK
10. Close the Registry Editor

=====
9.0 = xl2k
10.0 = xl2002
11.0 = xl2003





stevjones wrote:

Arial in Excell 2000 was NOT proportional spaced. I have just converted to
Excel 2003, where Arial (and just about every other type, too!) IS
proportionally spaced. With proportional spacing, numbers in a column do not
line up due to different spacing---particularly numbers like 111,111 versus
999,999. This is driving me crazy. Can anyone help? Thanks.


--

Dave Peterson
Reply
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
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
Bulleting text and spacing down a line in Excel Gord Dibben Excel Discussion (Misc queries) 0 January 24th 05 09:25 PM
Excel problem with web based spreadsheets Steve Williams Excel Discussion (Misc queries) 0 January 12th 05 02:11 PM
Can I merge Excel spreadsheets with Quickbooks invoicing? Ukcats_26 Excel Discussion (Misc queries) 1 January 11th 05 02:41 PM
Viewing Excel spreadsheets Jimbola Excel Discussion (Misc queries) 1 November 28th 04 06:59 PM


All times are GMT +1. The time now is 09:35 PM.

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

About Us

"It's about Microsoft Excel"