Right Align Numeric Values in SQL Server Management Studio

In SQL Server Management Studio (SSMS) there is an option to Right Align Numeric Values when using 'Results to Text' (Ctrl + T) mode.

By default results are left aligned:

numeric_values_left_aligned

To change the default to right align numeric values in 'Results to Text' go to 'Tools' -> 'Options' -> 'Query Results' -> 'SQL Server' -> 'Results to Text':

numeric_values_right_align

Check the option 'Right align numeric values' and Click 'OK'.

Queries in new windows will have the default option to right align numeric values in results.

To change the option for the current query only without changing the default behavior, right click on the query editor area and choose 'Query Options':

numeric_values_right_align_query_option

In 'Results' -> 'Text'
Check the option 'Right align numeric values' and Click 'OK':

numeric_values_right_align_query_options_text

Right aligned numeric values can be easier to read than left aligned:

numeric_values_right_aligned

Only numeric values will be right aligned, and only in 'Results to Text', not in 'Results to Grid'.