Adding $ to formula in numerous cells

**stba2006** · 08-13-2010, 10:38 AM

I was wondering if any-one could help please.

I am wanting to fix the cell reference on around 200 formulas (they are all in one column), so I am looking for a quick way to add the $ to these cells as I don't like the idea of doing this manually

Thanks

**meyero90** · 08-13-2010, 10:59 AM

can you attach a spreadsheet with some dummy data.
Thanks

**wmfinance** · 08-13-2010, 11:32 AM

Simply highlight the column and click on format cells. From there choose currency and ensure that the "$" is toggled on.

This will add a "$" to all the cells, and should work if I am understanding you correctly.

Regards

**martindwilson** · 08-13-2010, 11:48 AM

depends you can usualy do it with find/replace chunks at a time
find =A replace =$A find : replace:$ or find( replace ($ and so on

**wmfinance** · 08-13-2010, 12:44 PM

Oh I see what you are attempting to do...sorry for the misunderstanding. When you say "manually," do you mean that you literally click on the equation and enter the "$?"

If this is the case you could always just press F4 to reference that cell. Click it up to 3 times for different row/cell references. If you do mean this as manually, then I am not sure either...