Excel - Only formula shown on column, value not displayed. Solution: Highlight the cell contents and Press on CTRL + ~ . Value will be displayed accordingly.