I have a column of telephone numbers in Excel all starting with zero (0). When I save as CSV and re-open the zeros have disappeared! I've tried formatting in Excel as 'Text' and as 'General' before saving to CSV but the result is the same. Unfortunately, for the task I'm doing, I'm forced to use CSV and I must have the zero present at the start of each number.
Anyone got a solution please?
Cyril
Anyone got a solution please?
Cyril