#1
|
|||
|
|||
Excel deleted numbers
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 |
#2
|
|||
|
|||
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?
|
#3
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Retrieve page numbers in Word doc from set of variables in Excel file | smn | Word VBA | 6 | 06-29-2014 06:32 PM |
Excel simplify formula - array of sequential numbers | Wries | Excel Programming | 1 | 05-12-2014 08:32 AM |
How do I refer to page numbers, when the numbers change as I prepare the document? | StevenD | Word | 5 | 11-29-2012 12:52 AM |
Excel not entering numbers correctly | weety | Excel | 2 | 06-29-2011 01:07 AM |
creating unique numbers in excel | bignick270 | Excel | 1 | 05-17-2009 05:40 AM |