Hi Softrak Support, thanks for the reply. I have all my accounts in an "Adagio Financial Report" and they have been entered as apostrophe acct-dep (ie. '1234-123). When I export to excel they are perfect (in exactly the same format). However, when I import back into FRW they do a variety of things. I have about 750 accounts, but here's a couple of examples. My acct '6500-12 comes back as 12/01/00, '6500-13 comes back as '6500-13, and '1020-1 comes back completely blank. I can tell that somewhere in the intuitive chain, dept 12 is being interpreted as Dec but dept 13 obviously isn't. I'm just not sure how to fix it. I'm not sure why '1020-1 comes back blank. If you try these three accounts, I think you'll see what I mean.
I know I could be doing things a better way and using Financial Report Writer more effectively but for now I just want to build a few reports to get through my year end. Sorting in excel seems the best way for now. In the spring I'll hopefully revamp my "Bad" Chart of Accounts and start using SmartSheet etc.
Thanks - Sue