HOSP 187 Chapter Notes - Chapter 5: Dialog Box, Printf Format String

• School: University of Delaware
• Department: Hotel, Restaurant and Institutional Management
• Course: HOSP 187
• Professor: Zjisk

Document Summary

Two aspects of formatting are fundamental in any worksheet: cell appearance cosmetic details like color, typeface, alignment and borders, cell values controls the way excel displays numbers, dates and times. The basic principle behind cell value formatting is that the cell value that excel stores does(cid:374)"t (cid:374)e(cid:272)essaril(cid:455) (cid:373)at(cid:272)h the (cid:272)ell (cid:448)alue it displa(cid:455)s. In the format cells dialog box, the number tab lets you control how excel displays numeric data in a cell: excel uses number formats when the cell contains only numeric info. If you enter three numbers sepeated by dashes or forward slashes, excel assu(cid:373)es (cid:455)ou"re e(cid:374)teri(cid:374)g a data, a(cid:374)d adjusts the (cid:374)u(cid:373)(cid:271)er for(cid:373)at to date. If you choose the currency format, then you choose from dozens of currency symbols: when you use the number format, you can choose to add commas or parentheses. Is the o(cid:374)l(cid:455) for(cid:373)at other tha(cid:374) te(cid:454)t that does(cid:374)"t li(cid:373)it (cid:455)our data to a fi(cid:454)ed (cid:374)u(cid:373)(cid:271)er of decimal places.