Thread: Formula issue.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eduardo Eduardo is offline
external usenet poster
 
Posts: 2,276
Default Formula issue.

Hi,
you can remove all the $ sign using find and replace, press CTRL + H, find
what enter $, then go to the field replace with but do not enter anything and
click ok

"LCdebaca" wrote:

I am creating a formula to copy data from one cell to another and I always
get the $ in my formula. I do not want to copy the same data that is in that
cell, so I have to go in and manually remove the $. How do I fix this issue.