ckishore 72107
SSC Journeyman
Points: 82
More actions
May 17, 2011 at 12:56 am
#1325622
good catch!! SSCarpal:doze:
kbatta
SSCrazy
Points: 2274
May 19, 2011 at 8:05 pm
#1327452
What is the format of an Excel query that uses FORMAT?
Here are some rows from an Excel file that have the scientific notation problem. It is an .xls file.
NCPDP1
3356260
3329706
3350612
03350612
3337397
3313210
3340685
3332385
May 19, 2011 at 8:15 pm
#1327453
I tried saving the Excel file as 2007 format and the scientific notation bug went away.
oi21
SSC Rookie
Points: 44
May 20, 2011 at 12:40 am
#1327488
hey hi sunder can you just provide me demo excel sheet which contain these data i can look into that and i will solve this but i need excel sheet atlest some part of it
You can visit my blog and send me query i willl provide personal Email ID
http://bimentalist.wordpress.com
Viewing 4 posts - 31 through 33 (of 33 total)
You must be logged in to reply to this topic. Login to reply