decimal places for calculated variables

Hello,

At the end of my experiment subjects are given feedback about how much they earned. This is a calculated variable dependent on their own and others' choices during the study. Here's my problem: when medialab displays the earnings, there are about 10 decimal places (e.g. 11.33333333333). I'd like to limit it to 2 decimal places. I've tried formatting the cells in excel, but nothing seems to work. (By the way, the item type is fill-in-the-blank...I haven't had this problem for scale response items.) Any thoughts?

Thanks.

Have not done this before but you could try this. Create a new variable based on the value you want to use (e.g., 3.333333333) then in the value cell for that variable enter something like

[I]=TEXT(B1, "$0.00")[/I]

[I]or[/I]

[I]=TEXT(B1, "00.000")[/I]

And that sort of thing. I got thsi from the section on the "text" function in Excel:

[QUOTE]
Converts a value to text in a specific number format.
[B]Syntax[/B]
[B]TEXT[/B]([B]value[/B],[B]format_text[/B])
Value is a numeric value, a formula that evaluates to a numeric value, or a reference to a cell containing a numeric value.
Format_text is a number format in text form from in the [B]Category[/B] box on the [B]Number[/B] tab in the [B]Format Cells[/B] dialog box.
[B]Remarks[/B]
[LIST][*]Format_text cannot contain an asterisk (*). [*]Formatting a cell with an option on the [B]Number[/B] tab ([B]Cells[/B] command, [B]Format[/B] menu) changes only the format, not the value. Using the TEXT function converts a value to formatted text, and the result is no longer calculated as a number. [/LIST][B]Example[/B]
The example may be easier to understand if you copy it to a blank worksheet.
[/QUOTE]