G
Guest
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.
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.