| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
aligning decimal point in a column of figures in Excel
I am working on an Income & Expense statement using Excel 2000 and I like my
decimal points to line for appearances (just a quirk of mine). I am having trouble. Sometimes when I enter a figure it is lined up to the right of the column and then the next figure could be to the right but offset by one space so the figures aren't lined up. Is anyone having that problem? Have you found a solution? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
aligning decimal point in a column of figures in Excel
Select or highlight all of the cells with numbers, then click on the comma
icon on the toolbar. That will format all the umbers with 2 decimal places, aligned on the decimal point "Fonda" wrote: I am working on an Income & Expense statement using Excel 2000 and I like my decimal points to line for appearances (just a quirk of mine). I am having trouble. Sometimes when I enter a figure it is lined up to the right of the column and then the next figure could be to the right but offset by one space so the figures aren't lined up. Is anyone having that problem? Have you found a solution? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Decimal point will not hold 2 places in Excel 2003 | Excel Worksheet Functions | |||
| Excel should let you graph every n-th data point in a column | Charts and Charting in Excel | |||
| consolidation of tables in excel with text and figures | Excel Worksheet Functions | |||
| In excel, how can i delete 1 digit and the decimal point? | Excel Worksheet Functions | |||
| ADDITIONAL FIGURES IN COLUMN DON'T ADD TO TOTAL IN EXCEL | Excel Worksheet Functions | |||
Linear Mode
