| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Aligning data with varying decimal places
I have a column of cells in which the data include various numbers of decimal
places. Is there a way to align the data vertically so that the decimals line up, without adding trailing zeroes? |
|
#2
|
|||
|
|||
|
one way:
Format/Cells/Number/Custom 0.??? In article , edpaul wrote: I have a column of cells in which the data include various numbers of decimal places. Is there a way to align the data vertically so that the decimals line up, without adding trailing zeroes? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Entering numbers with variable decimal places. | Excel Worksheet Functions | |||
| Office 97 to 2003: Excel: enter data w/fixed 2 decimal. 2000. be. | New Users to Excel | |||
| Office 97 to 2003: Excel: enter data w/fixed 2 decimal. 2000. be. | New Users to Excel | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
| ROUND DATA TO 2 DECIMAL PLACES | New Users to Excel | |||
Linear Mode
