View Poll Results: were you saved by SQL?
Yes, SQL is like learning to run after crawling through excel 0 0%
no, It was to much hassel and I had to go back to hand sorting anyway 0 0%
What is SQL and why not just call it Access? 0 0%
no I learned to write macro's instead. 0 0%
Multiple Choice Poll. Voters: 0. You may not vote on this poll

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Fez Fez is offline
Junior Member
 
Location: Florida, Greece, from California
Posts: 2
Send a message via Skype™ to Fez
Exclamation Excel scrambles # series and enters=4.02E+11??

hi; first post to excel banter ;z)

I have a feeling that a 'feature' is being left on that is messing me u in Excel, and I need someone to tell me how to turn it off. ;z)

I have a column, of data like this....
422329310004
402310481007
402310481007
412022176003
402312133001
402301231025
402312133001
402301231025
412117151002
422310229011
422310229011
412117304011
412117304011
412117304011
402315383005
402315383005
402315383005

it goes and gets proccesed - IE: gets transferred to different formats & comes back as cvs. .... and I get...... which when click are only 2 unique for characters,.... out of like 12....

4.02E+11
4.02E+11
4.12E+11
4.12E+11
4.02E+11
4.02E+11
4.02E+11
4.12E+11
4.02E+11
4.12E+11
4.02E+11
4.02E+11
4.02E+11
4.02E+11
4.12E+11
4.12E+11
4.22E+11
4.22E+11
4.12E+11
4.02E+11

Simple question simple answer ;z) ;z)

Thanks in Advance,
Drew
  #2   Report Post  
Fez Fez is offline
Junior Member
 
Location: Florida, Greece, from California
Posts: 2
Send a message via Skype™ to Fez
Default

Well so far:
Yes by highlighting the cells in question and right clicking & selecting format'. You can choose 'nuber' from the list for example. This returns it to a string of $'s however only half the values are 'true', the other 1/2 or the last 6 of the 12 digits are just left with place holders='0' .
So there is still something going on...

Maybe when converting between different formats, you have, a different maximum length of digits..... I dunno I'm just guessing,

yours,
Fez
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Screen Scrambles ddoblank Excel Discussion (Misc queries) 1 February 10th 08 04:49 PM
Date enters wrong #'s Frustrated_rich99 New Users to Excel 2 December 7th 06 02:06 PM
find/replace enters search Excel Discussion (Misc queries) 2 January 31st 06 09:24 PM
Excel enters date as a text format Kane Excel Discussion (Misc queries) 3 March 22nd 05 10:20 PM
How to import a TXT with strings containing enters into Excel? Topje Excel Discussion (Misc queries) 1 March 4th 05 03:40 PM


All times are GMT +1. The time now is 01:38 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"