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

how i can show only the constant number after the comma
 

Hi

Have a look at the TRUNC worksheet function.

hth

Keith

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

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

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

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

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

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

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

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