Right-align numeric values in SSMS grid

Thanks to the post from Daniel Hutmacher ( https://sqlsunday.com/2018/06/12/right-align-columns-in-ssms/ ) I have found a great way to right-align numeric values in SQL Server Management Studio when viewing results in a grid.

CREATE TABLE #Numbers
( Number FLOAT
)
INSERT INTO #Numbers (Number)
VALUES (1), (1.5), (100.75), (1234.56)

SELECT
  Number,
  REPLACE(STR(Number, 15, 2), ' ', '  ')
    AS RightAlignedNumber
FROM #Numbers

DROP TABLE #Numbers