Left align numbers isn't quite left aligning 2

[bonwhit]

My report is essentially a form letter, and among other things contains 2 columns of information. The first column is all text objects, with the second column being the corresponding data. All are aligned on guidelines on the left and baseline. My data fields containing text data or currency data align left nicely. My data fields containing numbers left align, but with a little extra space, almost like they were formatted with a blank or maybe half a blank to the left of the number. As a result, they don't look like they are aligned at all. It is going to be hard to do an example with the display abilities of the forum , but here goes:

Label 1: Phrase
Label 2: 123456
Label 3: $12.34
Label 4: Phrase
Label 5: 6789

I'm using Crystal 9 on XP Professional, and displaying it with both the designer preview and the RDC.

Thanks for any help! This is driving me nuts - I am so picky about this kind of detail.

-- Bonnie

 

[MrBillSC]

Bonnie,

Chances are it has to do with format. The space may be for a negative indicator or minus sign. Try opening the format window for the numeric fields, click the "Custom" button and in the "Negatives" box select "None".

Hope this helps,

MrBill.

 

[bonwhit]

Mr Bill,

Perfect!! Thank you. :-D I must have tried every custom formatting option BUT that one. Fortunately, none of the numbers are negative, so I don't need that pesky little minus sign.

-- Bonnie