Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10
Default Numbers aligning in a table

Hi folks:

First of all, is there a feature in VB like the "PrintUsing ...." function
was in Basic?

I am trying to create & print strings made up of mostly dates & numbers of
various lengths by first converting them to text with the Text function. For
example, I have,

For report 1:
LineString1 = Birthdate$ &" "& HireDate$ &" "& TerminationDate$.....,
Wages$ &" "& Hours$" where

For report 2:
LineString2 = Age1$ &" "& Age2$ &" "& Service1$ & " "& Service2$ &" "&
Value1$.... &ValueN$ - all numbers.

where
yyyy$ etc are dates/numbers converted to text.

I am using the "Times New Roman" font size 10.
LineString1 prints OK for all records if there is no missing dates. But some
records may not have "termination date" and for those records the lines does
not align with the records which have "term dates" even though I insert
extra blanks equal to the length of the missing date which is in the
MM/DD/YY format.

I got LineString2 to print Ok for all records if all of the numbers are less
than a million (i.e. < or = 999,999). But if any of the numbers for a
record is a million or more, the lines will not align.

I could resolve this by using the "Courier New" font but the print comes out
lighter than the print in New Roman so I would like to stick with the New
Roman font.

Any suggestions on solving this problem would be appreciated (without
changing the font).

A thought just occurred to me - I could solve this if I knew how many blank
spaces in Time New Roman font would take up the space taken up by:
the forward slash (/), the comma (,) the dollar sign ($) and the
numbers 0 to 9.

I could figure this out by trial and error but does anyone know the spacing
equivalents?

Thanks.


--
Basharat Javaid.


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
aligning by decimal point - negative and positive numbers Melissa Excel Discussion (Misc queries) 4 October 4th 12 08:21 PM
Aligning rows. Help... Anders Excel Discussion (Misc queries) 1 August 12th 09 08:21 AM
Aligning numbers to the centre of the cell Ramesh Babu Excel Discussion (Misc queries) 2 July 1st 06 11:28 PM
Aligning decimal numers to the centre of the cell and aligning dec Ramesh Babu Excel Discussion (Misc queries) 1 July 1st 06 10:33 PM
Aligning Reference numbers ringnab Excel Discussion (Misc queries) 0 June 28th 06 10:57 PM


All times are GMT +1. The time now is 02:37 AM.

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"