Negative numeric data in parens in Excel but as minus in Access

From: "marilyn" <marilyn@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Tue, 26 Jul 2005 09:11:05 -0700

I am taking accounting data from Excel into Access to create reporting
statements. In Access, I am not maintaining the Excel negative number
format I have selected, and need to for my report.

Example :

(320) in Excel appears as -320 in Access.

I want (320) as the format in both. I can get ($320) if I change
field to Currency in Access but I really want to stay as a number and not
have the $ anyway.

What am I missing or how can I do this ? Saving as an .rtf and editing
is not a pretty thought.
--
Thanks very much,

Marilyn
.

Follow-Ups:
- RE: Negative numeric data in parens in Excel but as minus in Access
  - From: Klatuu

Prev by Date: How do I merge two different lists in Access?
Next by Date: RE: How do I close an open connection with Excel?
Previous by thread: How do I merge two different lists in Access?
Next by thread: RE: Negative numeric data in parens in Excel but as minus in Access
Index(es):
- Date
- Thread

Relevant Pages

Re: Is there a better way of doing this
... If you want to control inheritance from either A or B you can do ... What I am trying to do is create a reporting sistem, ... the future which should expand reporting system to XX format when ... But it looks like ugly hack and I don't consider myself to be Ruby ...
(comp.lang.ruby)
Re: crystal report print to file
... it can read from any ODBC/JDBC source ... It writes files to a standard XML format not some proprietary format. ... an extra dev tool or external reporting system as any kind of advantage. ... what MS licensing issues do you perceive to exist regarding CR? ...
(microsoft.public.vb.crystal)
Re: Date Formats
... > We have a reporting application that builds custom reports. ... We want to only query by month and year so the date field is ... There does not seem to be a date format for mm/yyyy using the ...
(microsoft.public.sqlserver.programming)
HTWWW DVD 3rd Quarter 2008?
... The Digital Bits website is reporting ... restored ("Smilebox" format?) DVD of "How the West Was ...
(rec.arts.movies.tech)
Re: Accounting changes
... Right now, the first field of the acct structure is the name of the command, which will always be a non-nul string, so always have a first character non-nul. ... This would provide backwards compatibility for reading old accounting data, which I would think would generally be desirable, and allow us to explicitly version the file in the future. ... Every time we change the type of a field of acct.h we will have to add architecture-specific code in the legacy file reading module. ... The approach I favor is to add to lastcomm an option to dump an accounting file in text format, and a second option to read text accounting data from stdin and write it out in the current accounting file format. ...
(freebsd-arch)