|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
April 23rd, 2006, 08:28 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Take fraction out of the figure
Hi.
I would like to extract the fraction part out of a number. For example: 1.5 - 0.5 23.45 - 0.45 25 - 0 Is there any simple way to do it? Thank you. -- Additional information: - I'm using Office XP - I'm using Windows XP 
|
|
#2
April 23rd, 2006, 08:51 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Take fraction out of the figure
Please don't multi-post. Your question has been answered already
-- Kind regards, Niek Otten "0-0 Wai Wai ^-^" wrote in message ... | Hi. | I would like to extract the fraction part out of a number. For example: | 1.5 - 0.5 | 23.45 - 0.45 | 25 - 0 | | Is there any simple way to do it? | Thank you. | | -- | Additional information: | - I'm using Office XP | - I'm using Windows XP | |
|
|
#3
April 23rd, 2006, 09:00 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Take fraction out of the figure
Did I? Where?
It must be a mistake. Sorry! PS: Later I found out the duplicate post in excel forum. Sorry about that. -- Additional information: - I'm using Office XP - I'm using Windows XP "Niek Otten" ¦b¶l¥ó ¤¤¼¶¼g... Please don't multi-post. Your question has been answered already -- Kind regards, Niek Otten "0-0 Wai Wai ^-^" wrote in message ... | Hi. | I would like to extract the fraction part out of a number. For example: | 1.5 - 0.5 | 23.45 - 0.45 | 25 - 0 | | Is there any simple way to do it? | Thank you. | | -- | Additional information: | - I'm using Office XP | - I'm using Windows XP | |
|
|
#4
April 23rd, 2006, 09:03 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Take fraction out of the figure - answer
Anyway I posted the answer here so to make the thread complete.
=MOD(A1,1) Thanks for your help. -- Additional information: - I'm using Office XP - I'm using Windows XP "Niek Otten" ¦b¶l¥ó ¤¤¼¶¼g... Please don't multi-post. Your question has been answered already -- Kind regards, Niek Otten "0-0 Wai Wai ^-^" wrote in message ... | Hi. | I would like to extract the fraction part out of a number. For example: | 1.5 - 0.5 | 23.45 - 0.45 | 25 - 0 | | Is there any simple way to do it? | Thank you. | | -- | Additional information: | - I'm using Office XP | - I'm using Windows XP | |
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Figure 1A, 1B, etc. in TOC | Kevin8237 | General Discussion | 3 | April 6th, 2006 06:56 AM |
| how do I link the text about figure number to the figure caption? | crystalxd | General Discussion | 1 | April 3rd, 2006 06:58 PM |
| Splitting a Target Figure | oldgit99 | Worksheet Functions | 3 | August 23rd, 2005 02:50 PM |
| Word - put in a tag for a figure to leave the next page blank | Sandy | Page Layout | 0 | August 16th, 2005 06:31 PM |
| converting text to numeric fraction | Amir | General Discussion | 9 | December 26th, 2004 02:57 AM |
Linear Mode
