• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel does not calculate

Joe269

New Member
Hi,
I'm trying to sort out some data imported from a database. Excel recognizes there is data in the cell but won't sum or auto sum. It will however count the content. Any help would be great.

Thanks
 

Attachments

json

Member
excel see the content in Col. A as text.... probably from the import process.

you'll have to somehow convert them to values in order to preform calculations.
 

Hui

Excel Ninja
Staff member
Joe269

Firstly, Welcome to the Chandoo.org Forums

Your column contains the Character using ascii code 160 at both the start and end of the number

Try the following

Select A1
Edit (F2)
Select the last character using Shift Left arrow, You won't be able to see it but trust me its there
Copy (ctrl C)
Esc, exits the formula edit mode
Select Column A
Data, Text to Columns
Delimited
Tick other and in the box next to other paste the character you copies using Ctrl V
Next
Change the Destination to another column eg B1
Apply
 

NARAYANK991

Excel Ninja
Hi ,

To add to what Hui has posted , the last 3 steps :

Next
Change the Destination to another column eg B1
Apply


are condensed to one step , if you click Finish instead of Next ; Excel automatically pastes the column data in column B.

Narayan
 
Top