Could this help ? http://superuser.com/questions/385511/easy-way-to-one-off-import-data-with-different-decimal-separator-in-excel
The solution is a bit old though and newer version of Excel may not offer the option anymore. On Sat, Jan 23, 2016 at 3:11 PM, Paolo Spanevello <[email protected]> wrote: > Dear Ted, > exactly this is the point. > > How could I fix this issue? > > Best, > Paolo > > 2016-01-23 23:27 GMT+01:00 Ted Dunning <[email protected]>: > > > Andries, > > > > But if you set Excel to use , as the decimal separator, then 925.0000 > could > > be displayed as 925,0000 > > > > Guessing by name, I suspect that Paolo is European and might have Excel > set > > this way. > > > > > > > > On Fri, Jan 22, 2016 at 9:26 AM, Andries Engelbrecht < > > [email protected]> wrote: > > > > > What does the JSON data look like? > > > > > > I did a quick test with Excel and MS Query through ODBC to connect to > > > Drill. > > > > > > Selecting data as either a string or numeric value. > > > > > > select * from (values('925.000',925.0000)) > > > > > > The results returned is > > > 925.000 for the string value and 925 for the numeric value to Excel. > > > > > > > > > With Drill 1.4 you can use typeof() to see what data type it being > > > interpreted as. > > > > > > --Andries > > > > > > > > > > > > > On Jan 22, 2016, at 8:50 AM, Ted Dunning <[email protected]> > > wrote: > > > > > > > > This sounds like this might be a problem of decimal point separator. > > Can > > > > you say what decimal point character you normally use? It might also > be > > > > that this is set differently on the exel machine from the machine > where > > > > drill is running. > > > > > > > > I am presuming that the value that you want to see is 925.0 > > > > > > > > Is that correct? > > > > > > > > > > > > On Fri, Jan 22, 2016 at 6:33 AM, Paolo Spanevello < > > [email protected]> > > > > wrote: > > > > > > > >> Dear All, > > > >> i'm drilling a JSON File with some fields with numbers with this > > format > > > : > > > >> > > > >> 1s_critical_power > > > >> 925.00000 > > > >> > > > >> > > > >> I'm using ODBC Driver to connect it on excel and the result aspect > is > > > >> > > > >> 1s_critical_power > > > >> 925,00000 > > > >> Do you know the right way to have it? > > > >> > > > >> Best regards, > > > >> Paolo > > > >> > > > > > > > > > -- Abdelhakim Deneche Software Engineer <http://www.mapr.com/> Now Available - Free Hadoop On-Demand Training <http://www.mapr.com/training?utm_source=Email&utm_medium=Signature&utm_campaign=Free%20available>
