I Go to format the column below with the custom format of ‘@’,
Before Formatting

When i Do it it only formats the Test and i then have to go into the cells with the number and update it manually.

Automatic calculation is on

below is the after formatting entire Column

enter image description here

I was expecting this value without have to update every cell
enter image description here
It has worked in the past dunno why its suddenly stopped