FORMATS (CURRENCY & ACCOUNTING)

D

davesfx

I have a quick question.

I have a workbook that when opened the format for a particular column
comes up as "ACCOUNTING". I would like to have it come up as
"CURRENCY". I know how to change it, so that is not the problem. The
problem that I am having is that somedays all the workbooks that we
exchange come up correctly as "CURRENCY" formats and then somedays they
all come up as "ACCOUNTING" formats. Is there a setting that I am
missing, or what can cause this?

This is very cumbersome as we exchange hundreds of workbooks back and
forth and everyone needs to have that particular column formatted as
"CURRENCY" not accounting and changing it really consumes some time.

Any ideas?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top