Number format

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pam - 23 Feb 2004 18:26 GMT

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?

Reply to this Message

wally - 23 Feb 2004 19:31 GMT

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

Reply to this Message

Graham Mayor - 24 Feb 2004 05:49 GMT

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

Signature

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

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

> 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?

Reply to this Message

Frank Tolstyka - 26 Feb 2004 17:32 GMT

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

Reply to this Message