FreePint: Join
Join FreePint and receive the Newsletter every two weeks for free.
Join now »
|
|
|
If you find FreePint useful, please supply
a testimonial »
|
|
FreePint Family:
Monthly magazine reviewing business information products »
Articles, tools, and a monthly magazine, to give you practical help with information skills »
Recruit for information-related roles, or find your next challenge. »
Daily update of web-based resources »
Daily update of free, full-text reports »
|
|
|
|
Home > Forum > Bar > Message |
|
|
Join FreePint and receive the twice-weekly Bar Digest and twice-monthly tip-packed Newsletter. It's free. [ more ]
|
|
|
|
The FreePint Bar is generously sponsored by Dow Jones Factiva.
|
|
|
| Start New | Message Index | Flat View |
| Excel query |
| Author: | Ian Gower |
| Date: | Friday, 19th Nov 2004 14:04 |
| Views: | 2,331 (excluding Digests and RSS feeds) |
| Category: | Computers and Software | | URL: | http://www.freepint.com/go/b30657 |
|
|
I am trying to set up a spreadsheet to calibrate a pesticide applicator. One of the cells to be filled in needs to extract just the decimal part of a previous cell. For example, if the original cell says 8.43, I just need .43 in the new cell. How can I achieve this please? |
|
| Start New | |
| Topic |
Author |
Date |
ID |
 | Excel query | | I am trying to set up a spreadsheet to calibrate a pesticide applicator. One of the cells to be ... |
|
Ian Gower |
19/11/04 14:04 |
30657 |
 | Re: Excel query | | A late entry here, because I wonder if you really want the decimal part or that is just part of ... |
|
Ian Savell |
26/11/04 18:11 |
30754 |
| | Re: Excel query | | Hi,
RIGHT is ok if you know the number of decimal places you have set. An easier way is to use ... |
|
Bradders |
23/11/04 14:18 |
30700 |
| | Re: Excel query | | Thank you for your replies, Bradders' example worked perfectly. |
|
Ian Gower |
24/11/04 17:21 |
30720 |
| | Re: Excel query | | To extract the decimal part of a number you can use the function RIGHT. This returns a text string. To ... |
|
J. Verbogen |
23/11/04 10:57 |
30688 |
Please note: The reply form is not showing because the posting is older than six months or the thread is locked. Please start a new topic or contact the forum administrator.
|
|
