I am making a database of names, addresses and telephone numbers using Excel 2003. When I type in telephone numbers and press enter, the first zero disappears. Ive tried all sorts of formatting, but can't find any solution. Anybody help, please?
Thanks for all the replies. I don't know whats happened, but some of the cells will accept the initial zero, but some drop them off as I hit ENTER. I've re-formatted all the cells in the "phone" column, but some cells have a zero and some don't. I have typed a ' asuggested by VoG™, that works but it puts a little green triangle in the top left hand corber of the cell. I've also tried foratting the cells as "text" and that seems to work, but I'm getting a bit confused as to why some cells are ok but others not, when they are all formatted the same.
The method VoG™ suggests works because by having a character that isn't one of the number digits, (0-9), Excel knows that this can't possibly be a number. Putting a ' at the front achieves this, and you can leave the cell formatted as "General"
So does a space.
If the number is, (with apologies to the person concerned if this is a real number!), 020 7555 5555, entering it like this
020 7555 5555 will not give a problem, because of the spaces.
entering it like this
Excel thinks it's a number, and the initial 0 isn't needed so drops it off.