how i can show only the constant number after the comma

Y

yasser

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
 
R

Ray

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
 
S

Sandy Mann

It returns 26 for me
Click to expand...

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

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
M

Mike H

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
 
P

Peter Creyf

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
 
P

Peter Creyf

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
 
Top