Excel cell formatting

[suresh244]

Hi,

Am doing bcpout into csv or excel file. The file having 10 columns. Afetr bcpout the data 3 columns data out of 10 columns showing the scientfic number data. please see below example:
ColumnA ColumnB
53859348954 53859348954
5353+E53.00 5353+E53.00

how avoide scientific number in the excel columns sing programmig or anytype. But pls don't reply saying that open excel sheet and make number as cell by mannually. It should be cnotrolled by program only.

Thanks
Suresh

 

[RonB1111]

In Excel, scientific notation has the E before the + sign, (eg: 5.353E+56). Your example has the E after the + sign, so to excel, 5353+E53.00 is a just a text entry.