avoiding multiplication

[weeclaire]

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?

 

[robert111]

consider 1.25 as a number

convert it to text =1.25

do a global search for the decimal point, replacing it with nothin
=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 i
universal by testing for where the decimal point is within the tex
string.

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

 

[Bernard Liengme]

You could type 100 in an used cell and copy it; select the 'problem' cells
and use Edit | Paste Special->Multiply.
best wishes

 

[weeclaire]

Thanks Robert111.

It is a preference of my employer.

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

 

[robert111]

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.