Donate SIGN UP

Excel Spreadsheets

Avatar Image
JessW | 07:20 Fri 10th Oct 2008 | Technology
1 Answers
Is there a way to add a zero to the beginning of a sequence of numbers in excel?

I have scanned a document listing peoples names and phone numbers via OCR but the column with the phone numbers has dropped the zero at the beginning.
Gravatar

Answers

Only 1 answerrss feed

Best Answer

No best answer has yet been selected by JessW. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
As long as you don't need to use formulas with the numbers in the cells, change the format of the cell to show the number as "text" - that will allow you to have the 0 at the beginning. (highlight all the cells, right click and select "format".

Only 1 answerrss feed

Do you know the answer?

Excel Spreadsheets

Answer Question >>