I want to enter in Access or Excel 9999 and have it formated as $99.99. How can I set this up?
K knowledge seeker Apr 28, 2009 #1 I want to enter in Access or Excel 9999 and have it formated as $99.99. How can I set this up?
J John W. Vinson Apr 28, 2009 #3 On Tue, 28 Apr 2009 09:40:05 -0700, knowledge seeker <knowledge I want to enter in Access or Excel 9999 and have it formated as $99.99. How can I set this up? Click to expand... Set the Format property of the field to Currency and the Input Mask to "999,999.00".
On Tue, 28 Apr 2009 09:40:05 -0700, knowledge seeker <knowledge I want to enter in Access or Excel 9999 and have it formated as $99.99. How can I set this up? Click to expand... Set the Format property of the field to Currency and the Input Mask to "999,999.00".
C Connor Gerney Apr 28, 2009 #4 Shudup!!! On Tue, 28 Apr 2009 09:40:05 -0700, knowledge seeker <knowledge Set the Format property of the field to Currency and the Input Mask to "999,999.00". Click to expand...
Shudup!!! On Tue, 28 Apr 2009 09:40:05 -0700, knowledge seeker <knowledge Set the Format property of the field to Currency and the Input Mask to "999,999.00". Click to expand...
