how i can show only the constant number after the comma

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Forget it that alters the number
Click to expand...

???

It returns 26 for me
--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
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
 
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, 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
 
Back
Top