This is the instruction for my spreadsheet. When I put #,##0,, for a custom format, I get 1 for 521,759

. Is this correct? And should I add a decimal to anything other than the ratios?

Note that for this class the profits and revenues are always

entered in millions. Data from annual reports as well as tables

in cases you will analyze are variously provided in thousands or

millions (or even billions) depending on the size of the firm.

Your instructor will expect all data entries to be in millions on

this worksheet. In addition, all numbers used in calculating

ratios should be to one decimal place, and all ratios should be

reported to one decimal place (except for EPS, which is two

decimal places).

SECOND