Decimal places

[deanl33069]

got this frmula here and it does work as long as my numbers are smaller than.10000

=LEFT(H29,3)&"."&MID(H29,4,1)
i need to have the decimal point 1 digit from the right. at ALL times

HELP

 

[Joe4]

Try this:

=LEFT(H29,LEN(H29)-1) & "." & RIGHT(H29,1)

Note that this will return a text value. If you need it to be numeric so you can do math on it, surround it in the VALUE function, i.e.

=VALUE(LEFT(H29,LEN(H29)-1) & "." & RIGHT(H29,1))

Alternatively, if it is a number with no decimals to start with, you can simply divide by 10, i.e.

=H29/10

 

[Fluff]

How about
=LEFT(H29,LEN(H29)-1)&"."&RIGHT(H29)

 

[DanteAmor]

You want something like this:

<table border="1" cellspacing="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:79.84px;" /><col style="width:76.04px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >H</td><td >I</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >29</td><td style="text-align:right; ">5.86</td><td style="text-align:right; ">0.8</td></tr></table><br /><table style="font-family:Arial; font-size:10pt; border-style: groove ;border-color:#00ff00;background-color:#fffcf9; color:#000000; "><tr><td ><b></b></td></tr><tr><td ><table border = "1" cellspacing="0" cellpadding="2" style="font-family:Arial; font-size:9pt;"><tr style="background-color:#cacaca; font-size:10pt;"><td >Cell</td><td >Formula</td></tr><tr><td >I29</td><td >=TRUNC(H29-INT(H29),1)</td></tr></table></td></tr></table>


Or you could give some examples of what you have and what you always expect of result

 

[Rick Rothstein]

[/I]=LEFT(H29,3)&"."&MID(H29,4,1)
i need to have the decimal point 1 digit from the right. at ALL times

Maybe this...

=0+TEXT(A1,"0\.0")

 

[deanl33069]

TY so much , Feel dumb for not thinking about the /10
sometimes u just need to walk away.

Dean

 

[Joe4]

You are welcome.
Glad we were able to help.