I have some C programs when I have to copy some number it shows attach pictures, I copied it in to the excel sheet.
But when I start calculation (Sum, Avg etc ) formula does not work, might be it is act as text.
I tried to change in Number by Ctrl+1 then number but not works.
Please any solution!
Highlight the cells that have the imported numbers that appear to be acting like text. With the cells highlighted, click on DATA > Text To Columns > Delimited > Next > Next
Make sure GENERAL is selected and click Finish.
Your numbers should act like numbers now.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks