CODEWITHSUNDEEP
excel
Suresh Alathur
Suresh Alathur

Reputation: 93

how to convert data from sql query to excel

i have sql query result like

 **ITEMID**                     **Str**
4 NITE       7891109372876
4 NITEK 
4 NITEICE GREY/BLACK     7891266811096
4 
4 NITEWHITE/BLACK        7890557462726
AERO GRA
AERO GRAPHICBLACK        7891266733404
AERO GRAPHICBLACK        7891266733411\

if i copied this result in excel the str format is changed like this

ITEMID                  Str
4 NITEBLACK
4 NITE  7.89
 GRAPHICBLACK   
AERO GRAPHICBLACK       7.89127E+12
sults in excel

Upvotes: 0

Views: 87

Answers (1)

Zakariaa.B
Zakariaa.B

Reputation: 133

right click on the cell --> format cells --> Choose a suitable category. Hope it helps ;)

Upvotes: 2

Related Questions