Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel scientific notation

Status
Not open for further replies.
dpdg

dpdg

Programmer
May 23, 2005
148
US
I have to update my database with data from excel spreadsheets. When Excel has numbers that it considers too long it changes the format to something like 6.10013e+009

Excel automatically formats long numbers into scientific format -- without you even telling it to. Is there any way to make it stop doing that? I have absolutely no use for that.

It stores the number correctly, but my SQL Server database grabs the 6.10013e+009 instead of the actual number. This format makes no sense to my clients. How do I read the actual number into SQL Server instead of the scientific notation?
 
Status
Not open for further replies.

Similar threads

Swi
  • Locked
  • Question
Read Excel Sharepoint File
Replies
0
Views
125
Swi
Swi
Niki_S
  • Locked
  • Question
How to read an excel file using VB 6?
Replies
17
Views
322
strongm
strongm
Niki_S
  • Locked
  • Question
Error in Excel/VB6 function: "Constant expression required"
2
Replies
31
Views
520
strongm
strongm
Niki_S
  • Locked
  • Question
How to read excel with a gap in vb 6? 1
Replies
2
Views
138
Niki_S
Niki_S
Niki_S
  • Locked
  • Question
How to insert excel sheet into sql server using vb 6?
Replies
6
Views
192
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top