M$ Excel driving me mad!!!
10 February 2003, 12:30 PM
#1
Scooby Regular
Thread Starter
Join Date: Sep 1999
Location: Bedfordshire
Posts: 4,037
Likes: 0
Received 0 Likes
on
0 Posts
Why o why when excel tries to be clever does it *always* f**k things up!!!!
Im importing some CSV values which contain credit card numbers and it always brings them in as xxxxE+15, if I try to change them to numbers then they round up, text leaves them in the same format (E+15). I thought it maybe because they are no double quotes around each column in the CSV file so I changed that but it still does it!!!
Been on this an hour and it should be a 1 minute job, aaaarrrgh, can anyone help me save my sanity????
cheers
Gary
Im importing some CSV values which contain credit card numbers and it always brings them in as xxxxE+15, if I try to change them to numbers then they round up, text leaves them in the same format (E+15). I thought it maybe because they are no double quotes around each column in the CSV file so I changed that but it still does it!!!
Been on this an hour and it should be a 1 minute job, aaaarrrgh, can anyone help me save my sanity????
cheers
Gary
Thread
Thread Starter
Forum
Replies
Last Post
Mattybr5@MB Developments
Full Cars Breaking For Spares
28
28 December 2015 11:07 PM
bluebullet29
General Technical
9
05 October 2015 02:17 PM