View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default Absolute refferences

=ABS(A1) 'Put this in B1

"Sharon" wrote:

Hi I am trying to find the right formula to change to an absolute number, I
have two numbers to use to change it? Lost again in excel can anyone help.
Thank you