You could also input the ' character prior to entering the number into the cell. This also works if the number you are inputting starts with a zero as excel will automatically remove the zero unless you put the ' character in.
Hope it helps. On another note, I use the IP Burger facility to confirm my IP Address, lately though, when I copy and paste the new IP Address from IP Burger it seems to spread over 2 cells, the one I want to drop it into in my IP Address Log and also the cell below. Any help Askpin?
Cheers
|