Shortcut to remove all dollar signs from all cells with formulas?

M

MarkH27

New Member
Joined
Jul 12, 2012
Messages
7
Using excel 2007


Isnt there a short cut to add and remove the dollar sign from formulas? I know I can go into an indiviual cell and highlight whatever part of the formula i want to add or remove dollar signs from by hitting the F4 key....but is there a way to highlight multiple cells and have all dollar signs removed?
 

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
Sort by date Sort by votes
Do a Find/Replace (CTRL+H) and search for $ and leave the "replace with" field blank, then click Replace all.
 
Upvote 0
Maybe I'm not understanding the question: you;re trying to remove all dollar signs from a formula, correct? A find/replace will do that.
 
Upvote 0
BenMiller said:
Maybe I'm not understanding the question: you;re trying to remove all dollar signs from a formula, correct? A find/replace will do that.
Click to expand...


no..you got it right....and I got the control H thing down for removing the $'s......but on the other side of the coin if I wanted to put the $ in all the formulas in all the cells is there a quicker way to do it than going into each cell...highlighting the formula and hitting F4? In my mind I see highlighting all the cells at once, hitting a short cut , then ta-da!..$'s in all the formulas.
 
Upvote 0
Hi Folks - trying to remove the dollar sign from multiple columns on a spreadsheet - have tried all the above but "MS excel cannot find any data to replace" is the reply I get each time - what am I doing wrong?
 
Upvote 0
Are the dollars part of cell references, or currency symbols?
 
Upvote 0
In that case I suggest you copy one from the formula bar then paste that into the replace dialog, just in case it's actually not a regular $ symbol. If the $ doesn't appear in the formula bar when you select one of the currency cells, then it's just number formatting that you can alter through the Format Cells dialog.
 
Upvote 0
You must log in or register to reply here.

Similar threads

N
  • Solved
Vstack, Chooserows & Dollar
2
Replies
18
Views
402
Nathan Asius
N
J
  • Question
Highlight in red all cells that have a formula with a mixed reference.
Replies
2
Views
284
Josecarlospdcj
J
Z
  • Question
Copy text value from one cell to another if all criterias are met
Replies
3
Views
612
zack8576
Z
C
  • Question
Delete Cell Range, or Add Range and Copy Formulas etc. - Excel VBA
Replies
0
Views
79
CSTjr
C
X
  • Question
Formula bar displaying SUM formula, but not its arguments
Replies
4
Views
280
KRice
K

Forum statistics

Threads
1,215,125
Messages
6,123,195
Members
449,090
Latest member
bes000

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top