deanl33069
Board Regular
- Joined
- May 2, 2019
- Messages
- 120
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
=LEFT(H29,LEN(H29)-1) & "." & RIGHT(H29,1)
=VALUE(LEFT(H29,LEN(H29)-1) & "." & RIGHT(H29,1))
=H29/10
Maybe this...[/I]=LEFT(H29,3)&"."&MID(H29,4,1)
i need to have the decimal point 1 digit from the right. at ALL times