Home |
Search |
Today's Posts |
#1
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
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
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
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 | | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need additoinal symbols for fractions | Excel Discussion (Misc queries) | |||
Splitting a Target Figure | Excel Worksheet Functions | |||
Show two rows as a fraction? | Excel Discussion (Misc queries) | |||
Excel will not allow me to change a numerical figure in a specifi. | Excel Discussion (Misc queries) | |||
how to type a minues figure | New Users to Excel |