Number format

[Pam]

I am pulling data into Word 2002 from SQL 2000 through a
stored procedure. Based on documentation I found to
format a dollar amount I should use \# ###.00. However,
if my amount is 35.50 it rounds the number to 40, which
is really bizzare. Why is it doing this? What can I do
to get it to display as $35.50?

 

[wally]

have yoiu tried #,###.##

----- Pam wrote: ----

I am pulling data into Word 2002 from SQL 2000 through a
stored procedure. Based on documentation I found to
format a dollar amount I should use \# ###.00. However,
if my amount is 35.50 it rounds the number to 40, which
is really bizzare. Why is it doing this? What can I do
to get it to display as $35.50

 

[Graham Mayor]

\# ",$#.00" should work - see
http://www.gmayor.com/formatting_word_fields.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP

Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

 

[Frank Tolstyka]

Pam:

I too have this problem with the formatting. I am using MS Query to pull my
data. It doesn't seem to be a rounding problem. I you can, see my post from
2/19. Your results will probably be the same.

Frank