no $ and want sum

using excel 2007 for windows

I want to take the $ off every field in column and sum the column
Who is Participating?
helpfinderConnect With a Mentor IT ConsultantCommented:
in case your dollar sign is not inserted as regular letter but it´s about cell format, select column you want, right click, select cell format and change from Currency to General or number
You could select the column and do a search and replace on the $, leaving the replace field empty.

Alternativly, add a new column and use a formula to strip the $ of the start i.e.

then a sum at the end of the column.

Guru JiCommented:
you can try this

=REPLACE(A1,1,0,"") and just drag if to entire column
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Sorry, that formula needs to also convert the string to a number :
rgb192Author Commented:
You could select the column and do a search and replace on the $, leaving the replace field empty.

error dialog box
can not find

I do not know where to type in the formulas
so I opened a new question

textfield above the field grid

where can I type in formulas for a column
windows excel 2007

I do not see a text field above the grid

how can I enable this (looks like a browser url text field above the webpages).
rgb192Author Commented:

b column is selected but becomes unselected when I do screenshot

I tried pressing checkmark

I press enter

how to input formula?how to input formula
rgb192Author Commented:
currency, no symbol

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.