| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how i can show only the constant number after the comma
dear sir
is there any can help me how i can show the constant number after the comma with out showing the fraction and with out changing the number. example: 800 * 30 = 26.6666 i want the result after typing the formua to show only the 26 with out the fraction many thanks yasser |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how i can show only the constant number after the comma
Hi
Have a look at the TRUNC worksheet function. hth Keith |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how i can show only the constant number after the comma
Try,
=INT(800/30) Mike "yasser" wrote: dear sir is there any can help me how i can show the constant number after the comma with out showing the fraction and with out changing the number. example: 800 * 30 = 26.6666 i want the result after typing the formua to show only the 26 with out the fraction many thanks yasser |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how i can show only the constant number after the comma
Forget it that alters the number
"Mike H" wrote: Try, =INT(800/30) Mike "yasser" wrote: dear sir is there any can help me how i can show the constant number after the comma with out showing the fraction and with out changing the number. example: 800 * 30 = 26.6666 i want the result after typing the formua to show only the 26 with out the fraction many thanks yasser |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how i can show only the constant number after the comma
Try this custom format...
Right-click on cell choose 'Format Cells....' select Number Custom enter ##, as the format ( that's 2 # signs and then a comma) Just be careful using this, as sometime it can mess up other formulas that are 'expecting' a value of 26 (assuming that the cell value is divided by 1000) but end up with 26,xxx instead! br//ray |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how i can show only the constant number after the comma
"Mike H" wrote in message
... =INT(800/30) Forget it that alters the number ??? It returns 26 for me -- Regards, Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how i can show only the constant number after the comma
"Sandy Mann" wrote in message
... It returns 26 for me Ah! seeing Ray's post the light dawns. I assume that the OP meant display 24 of 24,000 not display 26. I dismissed the talk of the coma thinking the the OP used commas in place of decimal points. Perhaps the OP will enlighten us -- Regards, Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how i can show only the constant number after the comma
Sandy,
It does but the number becomes 26 and the OP didn't want to change the number just the way it is displayed. Mike "Sandy Mann" wrote: "Mike H" wrote in message ... =INT(800/30) Forget it that alters the number ??? It returns 26 for me -- Regards, Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how i can show only the constant number after the comma
Yasser,
Which version of Excel qre you using. If you are using a version that is NOT the win 2007 version, you more than likely have an icon on your menu bar that decreases the number of decimals shown. Keep in mind though that this is just the appearance. The cell itself will keep the number with all the decimals, and depending on the size of the decimails (e/g/ .50 or not) it may round off up or down. The alternative way to do this, is to right click when you are in the cell, then left click properties - then choose the number tab on top and then select number from the list. On the right you'll see the number of decimals the cell will show. Peter "yasser" wrote in message ... dear sir is there any can help me how i can show the constant number after the comma with out showing the fraction and with out changing the number. example: 800 * 30 = 26.6666 i want the result after typing the formua to show only the 26 with out the fraction many thanks yasser |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how i can show only the constant number after the comma
Yasser, I just re-read your post. the function for that is Int (from
integer).. However, you cannot use that function all by itself in the same cell unless you are using a Visual basic "program". If it is OK to display it in another cell (say just to the right of the said cell), then in that other cell, type =Int(cell address) . So if you have the number 26.7 in cell A8, in cell A9, type =Int(A8) If you want it to shown in the same cell, you'll have to use VB. I don't know any VB, sorry... Peter "yasser" wrote in message ... dear sir is there any can help me how i can show the constant number after the comma with out showing the fraction and with out changing the number. example: 800 * 30 = 26.6666 i want the result after typing the formua to show only the 26 with out the fraction many thanks yasser |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can i multiply digits of a number by a constant in excel? | Excel Discussion (Misc queries) | |||
| Set a date as a constant to work back from to show only weekdays | Excel Discussion (Misc queries) | |||
| Set a date as a constant to work back from to show only weekdays | Excel Discussion (Misc queries) | |||
| When I type a constant number I want another number to appear. | Excel Worksheet Functions | |||
| Show comma in data validation list? | Excel Discussion (Misc queries) | |||
Linear Mode
