ANmarS - Search results

Excel/VBA expert since Sep 1997 (20 years 9 months)

We are moving ...

We are moving to another location, better, faster and more resources .... check it out ANmar.Systems

2 Q & A posts tagged with SPSS

Wed
May 12
2010

In Excel 2007, how do I make specific number values correspond to specific text values?

I'm trying to create a template for entering social science questionnaires, and SPSS has spoiled me. When I start entering the data, I want to able to type numbers and then have the correct text fill the box. For example, one question concerns race. I want to be able to type "1" and have "caucasian" automatically appear in the box. However, I want to RETAIN the number values so that I can easily run statistical analyses. Can Excel do this? Someone please help!


Answer

Yes, it can
This called VLOOKUP function, it is very popular and widely used

Here is a lesson on how to do that
http://www.vbaxlman.com/Lessons/?ID=b1vi…

VBAXLMan

Wednesday 5/12/2010 8:55:57 PM
Fri
Jan 16
2009

Does Excel 2007 return answers with more than 15 significant figures?

Can you do me a favour? If you are running Office 2007, can you go to Excel and type in any digit about twenty times?
My Excel 2002 loses interest after 15 significant figures and returns 0 after that. Thanks.


Answer

I did
1234567890 1234567890
And Excel converts it into
1234567890 1234500000

And when I did
1234567890 .1234567899
It converted into
1234567890 .12345

(I had to put spaces here to prevent Yahoo! from cut the number


So, it is the same as Excel2002, if you need a better one regarding this, use SPSS

VBAXLMan is back

Friday 1/16/2009 9:28:25 AM

Tags

History