No announcements
Found 1262645 threads
-
0 VotesDisable scientific notation in export to csv
How can I tell SSIS to export all my float values eg in precision 8 and no scientific notation?Answered | 3 Replies | 9281 Views | Created by Eld07 - Friday, February 6, 2009 8:44 AM | Last reply by Duane Douglas - Saturday, February 7, 2009 7:53 AM
-
0 Votes
scientific notation
Its because some are displayed in scientific notation and some are not.Answered | 12 Replies | 1538 Views | Created by ollp - Saturday, April 29, 2017 10:04 PM | Last reply by ollp - Tuesday, May 2, 2017 1:23 PM -
2 Votes
Long number in CSV file appearing in scientific notation by default
I CSV file contains only text (COMMA SEPERATED VALUES) and no formating.Answered | 12 Replies | 111049 Views | Created by Alistair_B - Thursday, November 25, 2010 12:47 AM | Last reply by Jobrus - Friday, January 22, 2016 9:15 AM -
1 Votes
EXCEL reads a text string as scientific notation
I have built an Add-In to completely avoid this problem of Excel converting CUSIPs to scientific notation.Answered | 15 Replies | 38605 Views | Created by Chuck Virtu - Monday, December 31, 2007 5:53 PM | Last reply by M.R.S - Saturday, August 31, 2013 5:24 PM -
1 Votes
some are scientific notation
Here is the same issue for your ...Answered | 3 Replies | 1025 Views | Created by runatyr - Friday, September 20, 2019 12:26 PM | Last reply by runatyr - Thursday, September 26, 2019 5:58 PM -
0 Votes
Storing and retrieving in scientific notation
I need to store and retrieve values in a scientific notation in the database.Answered | 4 Replies | 6439 Views | Created by Jahnavee - Thursday, September 2, 2010 5:40 AM | Last reply by Uri Dimant - Thursday, September 2, 2010 7:00 AM -
0 Votes
scientific notation SSIS
I'm carrying a excel file, monthly, for an data warehouse.Answered | 8 Replies | 7930 Views | Created by Dapego87 - Tuesday, July 29, 2014 9:38 AM | Last reply by Top112 - Monday, August 18, 2014 4:58 PM -
0 Votes
Problem with int, value is showing as scientific notation.
Yes, sorry looked at it again and it was hex notation.Answered | 3 Replies | 3215 Views | Created by chrima - Wednesday, October 28, 2009 6:04 PM | Last reply by liurong luo - Friday, October 30, 2009 8:58 AM -
0 Votes
Cast float TO varchar as scientific notation
I am trying to take a float (0.0000000000001) and show it in scientific notation as a varchar.Answered | 1 Replies | 3023 Views | Created by PebblesAndBambam - Friday, August 24, 2012 8:20 PM | Last reply by Tom Cooper - Friday, August 24, 2012 8:36 PM -
0 Votes
Assigning the Scientific Notation(with E) to Double Variable
Hi Feroz, Having float i = float.Parse("2e+7"), If you evaluate i and larger numbers, it's shown in scientific format.Answered | 2 Replies | 5843 Views | Created by Feroz Minnadad MS - Tuesday, June 29, 2010 4:02 AM | Last reply by Louis.fr - Tuesday, June 29, 2010 10:02 AM -
0 Votes
Float Data Value and Scientific Notation
Here you can see valueAnswered | 8 Replies | 14827 Views | Created by Malkesh - Friday, December 5, 2014 9:56 AM | Last reply by Malkesh - Saturday, December 6, 2014 2:27 PM -
0 Votes
Access 2007 Numbers display in scientific notation
In Access 2007 some numbers now display in Scientific Notation where in Access 2003 they did not.Answered | 1 Replies | 5042 Views | Created by NC_Matthews - Tuesday, December 7, 2010 2:40 PM | Last reply by John P Spencer - Tuesday, December 7, 2010 3:51 PM -
0 Votes
Remove scientific notation from xml column
Can i make any changes so that in xml column it self it store as i required without scientific notation.Answered | 2 Replies | 4390 Views | Created by IT researcher - Friday, May 24, 2013 10:19 AM | Last reply by Kalman Toth - Friday, May 24, 2013 6:33 PM -
0 Votes
how to store scientific notation, E.g. a number like 4.18456E-05
How to define a column that will store scientific notation such as 4.04984E-05, or 4.221155E-05?Answered | 4 Replies | 4631 Views | Created by SXQ - Monday, June 27, 2011 8:13 PM | Last reply by - Tuesday, June 28, 2011 5:24 AM -
2 Votes
no scientific notation in csv file
Numbers are being converted to scientific notation when file is generated.Answered | 22 Replies | 14480 Views | Created by Leading120 - Monday, February 10, 2014 4:29 PM | Last reply by ManikYOKO - Wednesday, January 20, 2016 11:52 PM -
2 Votes
Importing CSV file to SQL Server, Code Page and Data Type Issues
Assuming that Excel is the scientific notation culprit (which makes sense, thanks!)Answered | 5 Replies | 15298 Views | Created by Matt Brandt - Tuesday, August 7, 2012 5:26 PM | Last reply by Matt Brandt - Wednesday, August 8, 2012 12:18 PM -
0 Votes
Converting string without converting to scientific notation and without truncating decimals
Are you actually exporting to a text file and then importing into Excel and you see "1e+006" in Excel?Answered | 11 Replies | 17081 Views | Created by Naveen JV - Thursday, October 25, 2018 9:14 AM | Last reply by Rachel_Wang - Friday, October 26, 2018 6:50 AM -
0 Votes
Number of 16 characters (a credit card) from csv is transformed to scientific number when inserted in UIEditTextControl
If you open the .csv file all the way it will look fine in VS, just like a text file.Answered | 9 Replies | 5020 Views | Created by kis.roka - Tuesday, February 1, 2011 3:13 PM | Last reply by Starting0ver - Thursday, February 3, 2011 12:15 AM -
1 Votes
Entering a value that contains alphabet "E" that is along with numbers prefixed and suffixed(at either side of E) is considered as Scientific Notation by default
Hi Everyone, I need to enter values which would be like for example : 1234E90 But in excel they are treated as a scientific number and transformed as ...Answered | 4 Replies | 1003 Views | Created by Dola Nagaraja Kommu - Sunday, May 11, 2014 12:38 PM | Last reply by Joel Engineer - Monday, May 26, 2014 1:20 PM -
2 Votes
Display Axis in Exponential Notation
Hello, I would like to display the y axis values in a Winform Chart Control in scientific notation format but can't seem to locate any information on if/how this ...Answered | 2 Replies | 8406 Views | Created by ChrisBZ - Monday, June 4, 2012 10:08 PM | Last reply by sipla - Monday, September 10, 2012 9:13 AM - Items 1 to 20 of 1262645 Next ›
No announcements
