| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
fixed decimals
Is there a formula I can use to fix decimals on values already on a
spreadsheet? I am importing data from a database that assumes 4 decimal places, so a 70000 is really 7.0000. I tried using the fixed formula but that did not give me the desired result. I also went to Tools - Options - Edit - Fixed Decimal Places and set to 4 but that only helps for newly entered data. Please help! Thank You! --GREG-- |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Aligning decimals in Excel ... | Excel Discussion (Misc queries) | |||
| How do I override fixed decimal place settings in EXcel 2003? | Excel Worksheet Functions | |||
| Export to fixed width text file | Excel Discussion (Misc queries) | |||
| How do I display leading zeros so I can export a fixed in Excel? | Excel Discussion (Misc queries) | |||
| Difference between two dates in months with decimals | Excel Worksheet Functions | |||
Threaded Mode
