Toad World® Forums

exporting to excel

Hi

How do i get my exporting data to be reconized by excel as a number an not have to convert it every time?

i have the following line on my sql substr(iinvd.plas_prod_id, 13, 6) and i get this result

8461.Capture.png

thx

Try casting the resulting value as a number. When you substring the value it is a string.