| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 58535 | 2005-06-03 11:47:00 | Microsoft Excel | 2wontoks (8266) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 360953 | 2005-06-03 11:47:00 | Am new to Excel and having difficulty in settings to have figures always displayed with two decimals - particularly if the last two are both zeros. For example I need $45.00 displayed as that but it reverts to $45 only. The reason is largely so that it all lines up when I print a column of figures. Likely very easy but haven't yet located. Thanks for help. | 2wontoks (8266) | ||
| 360954 | 2005-06-03 12:11:00 | Several ways. 1. On the formatting toolbar if it is already on your excel installation, left click twice on the icon <-.0 .00 2. Right click on the cell(s) you want to have two decimal places, the left click on "format cells" and then on currency and select two decimal places. 3. Left click on format on the menu bar (near top of page), then select cells, then currency, then specify two decimal places. |
rugila (214) | ||
| 360955 | 2005-06-07 09:15:00 | Another quick way is to select the cell(s)/column/row and press Ctrl+Shift+1 to get 2 decimal places without the $ sign or Ctrl+Shift+4 to display the $ sign. Cheers. Roger |
RogerRamjet (7055) | ||
| 1 | |||||