avoiding multiplication
 

Hi
This is a bit of a stange one. I have some formula in a spreadsheet
and the results are currently showing with 2 decimal places e.g. 0.75,
1.25, 5.60. However I would like this to display without the decimal
places e.g. 75, 125, 560 without the need to include *100 in the
formula. Unfortunately it is not a percentage so I cannot use that
option as it then displays with the percentage symbol.
Anyone any ideas?
:confused:


--
weeclaire
------------------------------------------------------------------------
weeclaire's Profile: http://www.excelforum.com/member.php...o&userid=28738
View this thread: http://www.excelforum.com/showthread...hreadid=529140

avoiding multiplication
 

consider 1.25 as a number

convert it to text =1.25

do a global search for the decimal point, replacing it with nothing
=125

OR embed this in your formula


A1 = B1 / C1 B1=5 C1 = 4 therefore A1=1.25


A1=text((B1/C1),"0.00") = 1.25

A1=left(text((B1/C1),"0.00"),1) & right(text((B1/C1),"0.00"),2)

this only w0rks if all numbers are to 2 decimal places,you can make it
universal by testing for where the decimal point is within the text
string.

Why do you need to do this? eople may have a better idea for you.


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=529140

avoiding multiplication
 

You could type 100 in an used cell and copy it; select the 'problem' cells
and use Edit | Paste Special-Multiply.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"weeclaire" wrote
in message ...

Hi
This is a bit of a stange one. I have some formula in a spreadsheet
and the results are currently showing with 2 decimal places e.g. 0.75,
1.25, 5.60. However I would like this to display without the decimal
places e.g. 75, 125, 560 without the need to include *100 in the
formula. Unfortunately it is not a percentage so I cannot use that
option as it then displays with the percentage symbol.
Anyone any ideas?
:confused:


--
weeclaire
------------------------------------------------------------------------
weeclaire's Profile:
http://www.excelforum.com/member.php...o&userid=28738
View this thread: http://www.excelforum.com/showthread...hreadid=529140

avoiding multiplication
 

Thanks Robert111.

It is a preference of my employer.

Will give this a go at some point this afternoon or early tom.


--
weeclaire
------------------------------------------------------------------------
weeclaire's Profile: http://www.excelforum.com/member.php...o&userid=28738
View this thread: http://www.excelforum.com/showthread...hreadid=529140

avoiding multiplication
 

say your data is
1.25
25
0.75

and these are calculated by "your formula"

if(yourformula-int(yourformula)=0,yourformula,100*yourformula)

this tests for a whole number and leaves it as it is, otherwise
multiplies by 100

It won't work for one decimal place but that doesn't matter.


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=529140