Converting numbers

[Tompanilla]

Hi!

In a new daily report the amounts over 1000 looks like below and is not countable.
How can I delete the question mark so it is possible to sum the amounts.
Yhe report consists of about 1500 rows.

1?451,00
1?451,00
121
1?451,00
1?451,00
221
107
aso.

Thanks for help!
Thomas

 

[Aladin Akyurek]

Hi!

In a new daily report the amounts over 1000 looks like below and is not countable.
How can I delete the question mark so it is possible to sum the amounts.
Yhe report consists of about 1500 rows.

1?451,00
1?451,00
121
1?451,00
1?451,00
221
107
aso.

Thanks for help!
Thomas

=SUMPRODUCT(SUBSTITUTE(A2:A8,"?",0)+0)

If comma's should be periods...

=SUMPRODUCT(SUBSTITUTE(SUBSTITUTE(A2:A8,"?",""),",",".")+0)

 

[Scott Huish]

You could also do a Find and Replace.

Select your column and go into Find and Replace (CTRL-H)

Find What: ~?

Leave Replace with Blank.
Click on Replace All

 

[Tompanilla]

Thank you HOTPEPPER and Aladin Akyurek for your replies!
It easily solved my problem.
Brgds from a sunny Jonkoping in Sweden

 

[Aladin Akyurek]

Thank you HOTPEPPER and Aladin Akyurek for your replies!
It easily solved my problem.
Brgds from a sunny Jonkoping in Sweden

Great. Thanks for providing us feedback.