Right and Left justification

[MimiCush]

I am using Excel 2013. I have a column in a table that is defined as text. It will usually hold a whole number and I want it right justified. At times there will be text and I want this left justified. I have the column formatted as right justified. I had a brilliant idea to conditionally format it when it is not numeric as left justified. Unfortunately, that is not an option of conditional formatting.

Any ideas?

[Logit]

Use the Worksheet_Change Event (in the sheet module) to check for that column.

If not numeric then macro code to right justify, otherwise it will always be left justified.

[p45cal]

Try removing all justification formats from that column, it should look after itself.

[MimiCush]

Originally Posted by p45cal

Try removing all justification formats from that column, it should look after itself.

I was overthinking. So simple. Thank you.