Issue in Cell Value Alignment

[Guest]

Hi,
I am exporting data to each cell through an OLE function. I am using
WIN2K Prof OS and Office 2K.

When I export data to each cell, values are right aligned. All the cells
are right aligned, but some cells are not exactly right aligned. for Eg.

|----------|
| 123|
|----------|
| 123 | -> Though right aligned, not properly... Why?
|----------|

Can any one explain me the cause and solution. If I set "WrapText" true...
then it works fine.

Any help appreciated.

Thanks

With Regards
Venkay

 

[Dee]

Could it possibly be that your cell is formatted
differently? Both with number but one with the negative
as a "-" as in "-123", and the other with the negative in
parentheses as in "(123)". The parentheses will leave a
little room on the right to allow for the parentheses so
that the digits will align correctly whether it's a
positive or negative number.

Dee
Reston, VA