View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Remove the $ from a cell reference

Les,

If it's only a single cell then why not just re-type as A25 or select it and
tap F4 a few times until the reference becomes relative.

Mike

"Les" wrote:

Hi,

could anybody help with this please ?

I need the cell reference to read A25 and not $A$25

Any help much appreciated
--
Les