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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

marilyn - 26 Jul 2005 17:11 GMT

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.

Signature

Thanks very much,

Marilyn

Reply to this Message

Klatuu - 26 Jul 2005 17:21 GMT

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.

> I am taking accounting data from Excel into Access to create reporting
> statements. In Access, I am not maintaining the Excel negative number
[quoted text clipped - 10 lines]
> What am I missing or how can I do this ? Saving as an .rtf and editing
> is not a pretty thought.

Reply to this Message

marilyn - 26 Jul 2005 20:08 GMT

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

> 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
[quoted text clipped - 14 lines]
> > What am I missing or how can I do this ? Saving as an .rtf and editing
> > is not a pretty thought.

Reply to this Message

Klatuu - 26 Jul 2005 20:24 GMT

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

> 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
[quoted text clipped - 25 lines]
> > > What am I missing or how can I do this ? Saving as an .rtf and editing
> > > is not a pretty thought.

Reply to this Message