0

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
Improve this question
1
  • 1
    You already do. There is no string format involved, this is numeric data. Just change the format of your Excel column to the format you want. Commented Jan 20, 2016 at 11:21

1 Answer 1

Reset to default
2

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

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.