>>>If it's numeric
>>>
>>>FormatMask = '000-00-0000'
>>>
>>
>>It's character. Also I don't like numbers aligned to the right. I'm going to transform data while preparing.
>
>Yes, I think that's your best bet. Excel's help does not show much about text formating
Yes, and it's simple enough <g> It would be a different case, if I need to directly copy data.
If it's not broken, fix it until it is.
My Blog 
