"Accounting" Number Format
Have you tried using the Currency in the format property of the table or
query?
For more ideas check help on the format property -
Please minimize your cross-posting to a couple of groups max. Settle on one
or two groups that seem likely to offer you the best response and leave it
at that. Thanks.
--
Sandra Daigle
[Microsoft Access MVP]
Please do not respond by email, but to the newsgroup so that others can
benefit.
Quote:
> I would like my numbers to appear in the following format
> (which is listed in Excel as "Accounting"):
> $ (35,000.00)
> $23,563,389.00
> $ 10.77
> Any ideas how I would do that? I tried copying and pasting
> the actual format of Excel into the "Format" Property (by
> selecting "Accounting", and then clicking "Custom" to view
> the format, but no luck.
> Thanks in advance,
> Sean
