Message #65496

[gee4]

Actually we use stuff every day but it just doesn't register that it's a tip.

I used one earlier today.

Spreadsheet of data, amongst which were contact mobile nos.  All entries had the zeros missing at the beginning of the number.  To fix -

- Highlight the Cells
- Choose Format Cells
- Select Custom
- In the Custom box type 7 zeros

Your list should return the zeros at the beginning of each mobile number.