How do you stop the zero at the start of a phone number being deleted in a excel spreadsheet?

If it's just a phone number it will never be used in calculations so you need to format the cells as Text. Either select the entire column or row that is going to contain the phone numbers before you enter anything and format it as text - Format... Cells menu or type an apostrophe (') before each phone number as you type it Please note that, while this is a good system for phone numbers, it is a very bad system for any numbers that may be used in calculations because they are no longer numbers, but text strings Another Answer If you need to have leading zeroes before any number you will have to use the "Format Cells" option. In the "Number" tab go to the "Custom" option (It is usually the last on the list).

Type "0## #### ####" OR whatever numbers you require. In the above format, if you enter the number 1234567890, it will display as "012 3456 7890". (You can use the data as numbers if you want to also).

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.

Related Questions