Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-27-2014, 11:49 PM
ep2002 ep2002 is offline Excel deleted numbers Windows 7 64bit Excel deleted numbers Office 2010 64bit
Advanced Beginner
Excel deleted numbers
 
Join Date: Jun 2012
Posts: 83
ep2002 is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 08-28-2014, 10:45 AM
gebobs gebobs is offline Excel deleted numbers Windows 7 64bit Excel deleted numbers Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

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?
Reply With Quote
  #3  
Old 09-19-2014, 04:04 AM
ep2002 ep2002 is offline Excel deleted numbers Windows 7 64bit Excel deleted numbers Office 2010 64bit
Advanced Beginner
Excel deleted numbers
 
Join Date: Jun 2012
Posts: 83
ep2002 is on a distinguished road
Default

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
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel deleted numbers Retrieve page numbers in Word doc from set of variables in Excel file smn Word VBA 6 06-29-2014 06:32 PM
Excel deleted numbers 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 deleted numbers Excel not entering numbers correctly weety Excel 2 06-29-2011 01:07 AM
Excel deleted numbers creating unique numbers in excel bignick270 Excel 1 05-17-2009 05:40 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:11 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft