value attached to a name

macropod · #3 04-10-2011, 03:40 PM

Quote:

Originally Posted by grilem2

is it possible to have a name in a cell such as 2-way and have a fixed value say -4 attached to it?? so if i type 2-way in a cell the formula will automatically use that value.

As Kimberly says, names can't start with numbers - they can start with letters or an underscore. So you could define a name as _2Way, set its value to '4' (instead of using a cell reference), then reference the name via a formula. For example:
=A1*_2Way

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
3 Simple Questions (screenshots attached)	smaan	Word	1	03-08-2011 12:46 AM
Problem: Open attached Word file	markg2	Outlook	0	02-09-2011 09:18 AM
Hyperlink to attached file in email message	spino	Outlook	0	08-05-2010 05:56 AM
Macro to determine attached template	zippyaus	Word VBA	0	03-02-2010 02:05 AM
Outlook xp slow when Browsing to attached a file	jmelgar1	Outlook	0	09-23-2008 01:49 PM