1. It could be trying to use a different character set in those cells
Or, the Arial font could be somehow corrupted. It's definitely a display issue because I can see that the formula shows correctly above on the toolbar. All those weird characters appear to be replacing a single dollar sign (if my assumptions about the cells are correct).
From looking at the spreadsheet, it might be worthwhile for your friend to invest in Quickbooks. They even have a free "starter" version that I saw advertised on TV the other day that would probably be sufficient for something like this.
Changing the Excel default font to something else. Go to tools, options, general tab and change the font to something similar, say Sans Serif. Restart Excel and see what happens.
4. I suggested he do that too. I couldn't tell him where they might be
because I know Linux and OSX, not Windows.
Thanks for giving the path.
This guy is a real smart guy and no technophobe, but he has a real hard time with tasks like importing bookmarks and simple trial and error solution. I've thought of getting a cheap Win box so I can help him better.
He wants to put a dollar sign in the field with numbers. I think that could be part of the problem. The fields are either text or numbers. Maybe he should add a field for the currency designation.
Powered by DCForum+ Version 1.1 Copyright 1997-2002 DCScripts.com
Software has been extensively modified by the DU administrators
Important Notices: By participating on this discussion
board, visitors agree to abide by the rules outlined on our Rules
page. Messages posted on the Democratic Underground Discussion Forums are the
opinions of the individuals who post them, and do not necessarily represent
the opinions of Democratic Underground, LLC.