Absolute refferences

's Computer Specifications

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

's Computer Specifications

If the number is in A1, then =ABS(A1)

Tyro

"Sharon" <(E-Mail Removed)> wrote in message
news:F3CF7C68-F2F3-42A3-A902-(E-Mail Removed)...
> 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

's Computer Specifications

=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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to copy an array without changing relative cell refferences?	Dmitry	Microsoft Excel Worksheet Functions	12	20th Jun 2006 02:07 PM
How to copy an array without changing relative cell refferences?	Dmitry	Microsoft Excel Programming	12	20th Jun 2006 02:07 PM
How to copy an array without changing relative cell refferences?	Dmitry	Microsoft Excel Discussion	12	20th Jun 2006 02:07 PM
Absolute references in Conditional Formating not absolute (2003)	=?Utf-8?B?QS1KQQ==?=	Microsoft Excel Crashes	0	26th May 2005 12:06 AM
Message Box With Cell Refferences	Minitman	Microsoft Excel Programming	2	10th May 2004 06:21 PM