no $ and want sum

using excel 2007 for windows

I want to take the $ off every field in column and sum the column
LVL 1
rgb192Asked:
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
0
 
alicainCommented:
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.
 =right(a1,len(a1)-1)

then a sum at the end of the column.

Regards,
Alastair.
0
 
Guru JiCommented:
you can try this

=REPLACE(A1,1,0,"") and just drag if to entire column
0
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.

 
alicainCommented:
Sorry, that formula needs to also convert the string to a number :
   =value(right(a1,len(a1)-1))
0
 
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).

http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_28338603.html
0
 
rgb192Author Commented:
=value(right(b1,len(b1)-1))

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
0
 
rgb192Author Commented:
currency, no symbol

Thanks
0
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.