I built some forms in Excel 2007 and saved it compatible to 2003 on my
computer at home. When I loaded it onto our network drive at work where all
the computers have Excell 2003, some of my code didn't work. For example, I
had to change from
txtDate.Text = Format(txtDate.Text, "mmm dd, yyyy") to read
txtDate.Text = Format(txtDate.Text, "[$-409]d-mmm-yy;@")
Here 's my problem. The program works on 5 of 6 computers. On one computer
I get an error on this code...

Private Sub txtShiftTotal_Change()
txtShiftTotal.Text = Format(txtShiftTotal.Text, "$ ###,###")
End Sub

Why would 1 computer be different than the rest? Is there some add-in or
update I should be looking for?
Is there some other code I could use to format the text box to $ isth commas
and no decimals?

Thanks for any help or ideas.