You could enter your number in a worksheet cell (for example, A1
) and format it as desired. Next, select the shape, and type =A1
in the formula bar. The shape will reflect the value and formatting of A1
, updating automatically when changes are made.