Hi - I'm trying to get text from a datasource into a specific format on another Sheet. I've created a new table style and that works fine. However, whenever new rows are added, it will not align the text automatically, and has to be done manually after the event. The datasource is an excel dump from another program, so I can't format there and preserve input formats, and I don't want to use VBA.

I'm sure there must be a simple option somewhere, but I just can't find it!!!!

Thanks in advance