**Question description:**

*This user has given permission to use the problem statement for this blog.*

Can't add (SUM) in imported numbers from bank account

Solved by F. C. in 40 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
20/08/2018 - 12:26

HI

Excelchat Expert
20/08/2018 - 12:26

Welcome to Got it Pro

Excelchat Expert
20/08/2018 - 12:26

Please tell more about the requirement so that i can help better

User
20/08/2018 - 12:27

On an imported spread sheet from my bank account, the SUM function won't work

Excelchat Expert
20/08/2018 - 12:27

Can you share the data on the spreadsheet so that i can have a look

Excelchat Expert
20/08/2018 - 12:27

Please show me where the sum function is not working

Excelchat Expert
20/08/2018 - 12:31

Are you there?

Excelchat Expert
20/08/2018 - 12:31

Please share the data so that i can help you out

Excelchat Expert
20/08/2018 - 12:32

Where is the sum required?

User
20/08/2018 - 12:32

each column

User
20/08/2018 - 12:34

Are you still there?

Excelchat Expert
20/08/2018 - 12:34

Yes

User
20/08/2018 - 12:34

ok

Excelchat Expert
20/08/2018 - 12:34

The numbers are not in proper format

Excelchat Expert
20/08/2018 - 12:35

they are not copied in number format

User
20/08/2018 - 12:35

How do I change that?

User
20/08/2018 - 12:35

Because that's how they come when I import them

Excelchat Expert
20/08/2018 - 12:36

They are plain text and symbol before them is making the difference

User
20/08/2018 - 12:37

OK, I'll try highlighting all the numbers and making them currency

User
20/08/2018 - 12:38

do you think that will work?

Excelchat Expert
20/08/2018 - 12:38

Get rid of symbols and then convert to numbers

User
20/08/2018 - 12:39

How can I get rid of the symbols?

Excelchat Expert
20/08/2018 - 12:39

while importing try to get rid

User
20/08/2018 - 12:39

without having to delete each one

User
20/08/2018 - 12:40

Too late ---- I've already got hours into this spreadsheet since importing

Excelchat Expert
20/08/2018 - 12:41

See column O

Excelchat Expert
20/08/2018 - 12:41

Do you see?

User
20/08/2018 - 12:42

yes

Excelchat Expert
20/08/2018 - 12:43

See column P

Excelchat Expert
20/08/2018 - 12:43

and then see cell P302

Excelchat Expert
20/08/2018 - 12:43

Let me know if this helps

Excelchat Expert
20/08/2018 - 12:43

this is how we can do

User
20/08/2018 - 12:43

So... what did you do?

Excelchat Expert
20/08/2018 - 12:44

In column O i extracted the number right of euro sign

Excelchat Expert
20/08/2018 - 12:44

then converted them to number using value function

Excelchat Expert
20/08/2018 - 12:44

and then sum in P302

Excelchat Expert
20/08/2018 - 12:44

Do you understand?

User
20/08/2018 - 12:45

How did you extract the number?

Excelchat Expert
20/08/2018 - 12:45

using this

Excelchat Expert
20/08/2018 - 12:45

=MID(A2,2,LEN(A2)-1)

User
20/08/2018 - 12:45

each column?

User
20/08/2018 - 12:46

Let me try

Excelchat Expert
20/08/2018 - 12:46

Sure

Excelchat Expert
20/08/2018 - 12:49

Please do give good rating and reviews..it really helps

Excelchat Expert
20/08/2018 - 12:56

Are you there?

Excelchat Expert
20/08/2018 - 12:56

Please let me know if you need any more help

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*