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

[marilyn]

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.

 

[Klatuu]

Access will not pick up the Excel formatting, only the value. Are you
putting this on a report? If so, set up the formatting you need in your
report.

 

[marilyn]

Klatuu, how do I format in the report. I chose the Standard prperties
format as I nedd the commas but that does not yield the parens. I think I
tried to define a four part property format ( pos, neg, 0 and null ......
#,##0;(#,##0);0;" " in the property format but that did not work)..
I am a rookie so can be missing a lot...
more help ?


Thanks very much,

Marilyn

 

[Klatuu]

I don't know about the " " for Null. What you have is very similar to one I
pulled from one of my reports that is almost identical with the exception of
the [Red] which causes the text to be red for negative amounts. Try
replacing the " " with 0 and see what happens.

#,##0;(#,##0)[Red];0;0