After dropping a field into the Row Fields area, the row data will be
aligned in the center. But since it is text, I want to align it to the
left. How to do that? I guess it's no use just changing the cell
formatting.

Thanks!

format the cells.

--
Regards,
Tom Ogilvy


"blackpuppy" wrote:

After dropping a field into the Row Fields area, the row data will be
aligned in the center. But since it is text, I want to align it to the
left. How to do that? I guess it's no use just changing the cell
formatting.

Thanks!

I tried this out. Once I refresh the data using menu Data -- Refresh
Data, the formatting will be gone.

Sorry, I didn't state my scenario completely. I am using a .NET
WinForm app to control the Excel programmtically. The data will be
generated as XML and imported into Excel. So every time, I need to
refresh the data.

Any other ideas?

Thanks!