Hi,

So I'm livid now. I didn't even think to check to make sure that Excel was deleting my entries (why would I)?, but I just noticed twice now that Excel deleted the last digit of the number I pasted into a column. Who knows how may other entries it changed.

This last one had a zero & it removed the zero. I don't remember what the last number of the other entry was.

There is no way I can go back now & check all my work, that would take at least 3-5 hours

I was copying longs/lats from a long/lat site where you enter in the city or neighborhood & it gives you the data.

With this last one I tried to re-paste it in 2 more times before I realized it won't stop changing the number, so I changed the cell from "general" to text which left aligned the number so it doesn't look the same as all the others, but why did it do it & how can I stop it?

Should I just change the entire column to text?

If I change the whole column to text do you think it will bring back the missing numbers for any entries it deleted? I suspect not, but I have to ask with hope. <sigh>



Thanks


Michelle

Can you give an example of the number and what it's changed to? It might even be a quirk of the site you are copying from? Can you link it?

Hi,

Sorry, I had to get the work done & my client told me what the issue was.

You have to click on some button that adds zeros to the number. Excel was deleting the zeros whether it was 1 all the way upto 3.<sigh>

I'm really not liking Excel the more I use it.

Excel cost me TONS of hours I had to work for free just to fix problems it caused.

Thanks