Making a name worth a value

M

Melissa

For example

Dollar to equal 1.0
So, when you enter dollar you get the value 1.00 to display
 
J

JulieD

Hi Melissa

Insert / name / define - type name in top row, under refers to type =value
(=1) and press Add

Regards
JulieD
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I display text when a cell value is 0 for accounting? 0
SUMIF() to add cells in non-contiguous ranges? (Excel 2003) 4
users must enter value = or > than a certain value 3
Help with lots of formulas 3
Is this possible? 0
Input dollar amount into a cell that updates another cell and more 7
Replace values with text 1
Reference to worksheet in chart 0

Top