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?

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.

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" <[email protected]> wrote
in message news:[email protected]...
>
> 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?
>
>
>
> --
> weeclaire
> ------------------------------------------------------------------------
> weeclaire's Profile:
> http://www.excelforum.com/member.php...o&userid=28738
> View this thread: http://www.excelforum.com/showthread...hreadid=529140
>

Thanks Robert111.

It is a preference of my employer.

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

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.