S
scott
I have a query with a phone number. The number is split
into 3 cells
cell 1 is area code
cell 2 is prefix
cell 3 is suffix
Our system drops the leading zeros from the suffix so if a
number is 0123 it will only show 123.
Right now all every cell is aligned to the right..I am
assuming this is automatic..I didnt do anything for this
to happen.
Someone was nice enough to give me the following formular
to get the leading zeros back
Right$("0000" & [MyField], 4)
the problem is when I use this...it aligns the text to the
left of the cell now and I cant figure out how to get it
back to the right.
Thanks
Scott
into 3 cells
cell 1 is area code
cell 2 is prefix
cell 3 is suffix
Our system drops the leading zeros from the suffix so if a
number is 0123 it will only show 123.
Right now all every cell is aligned to the right..I am
assuming this is automatic..I didnt do anything for this
to happen.
Someone was nice enough to give me the following formular
to get the leading zeros back
Right$("0000" & [MyField], 4)
the problem is when I use this...it aligns the text to the
left of the cell now and I cant figure out how to get it
back to the right.
Thanks
Scott