| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Data manipulation help required !
I am wanting to carry out a calculation on only one part of a particular result in a calculation made in a spreadsheet ie if i have the result of "2.57945" how do i get excel to then only select the digits after the decimal point for further calculations ie ".57945" bearing in mind the whole number will not always be a fixed value. -- gramsey ------------------------------------------------------------------------ gramsey's Profile: http://www.excelforum.com/member.php...o&userid=16143 View this thread: http://www.excelforum.com/showthread...hreadid=275773 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with data not getting plotted | Excel Discussion (Misc queries) | |||
| Help with data not getting plotted | Charts and Charting in Excel | |||
| Charting data ranges that change | Charts and Charting in Excel | |||
| Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
| Data Table - Does it work with DDE links and stock tickers? | Excel Discussion (Misc queries) | |||
Threaded Mode
