Hi,
I haven't looked at your sample sheet but I am quite sure that both the behaviours you describe are because the table cells are formatted as Text. To remediate, select the entire problematic column, press CTRL+1 to open the Format cells dialog, choose General and click OK. That should fix it.
|