| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Entering numbers with variable decimal places.
I have scientif numeric data that is entered into cells on a monthly basis.
The data may change decimal places from month to month depending on what the reported lab value is. For example a lab report may read 1.1 for a particular month and then 1.22 for another month. Is there a way to enter this data freely without having to reformat the decimal places in a range of cells for these variations? -- Thanks - Jack |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| all the cells in excell put 2 decimal points in all numbers no ma. | Excel Discussion (Misc queries) | |||
| add 2 decimal places | Excel Discussion (Misc queries) | |||
| ROUND DATA TO 2 DECIMAL PLACES | New Users to Excel | |||
| Significant figures (not decimal places) | Excel Worksheet Functions | |||
| Decimal places in Excel 2003 | Excel Worksheet Functions | |||
Threaded Mode
