To change the format of the cell data, right-click the cell. Select Data Format.
A preview of the value for each cell will display to the right of the selected grip.