If you still see leading zeros, double-click the cells, then press ↵ Enter or ⏎ Return.