Jim H said:
trying o figure out how you set the followiong two
properites globally
1/ Dollar format
2/ Directory that yur save files into
1. Do you mean so that every new workbook that you open will have all cells
formatted as currency? If so, you need first to format a blank workbook
like this. Group all worksheets (click the tab of the first, then hold down
SHIFT and click the tab of the last). Then click the square at the
intersection of row numbers and column letters to select all cells, and
apply a currency format. Save this as the default template book.xlt in your
xlstart directory. (You also need to save a template sheet.xlt so that any
new worksheet added will be of this default format.) See "templates,
customizing workbook defaults" in Help for full details.
2. Tools > Options > General tab, Default file location
