I have a sheet where the formulas of E, F, and G are (in this example looking
at row 16)

ColumnE =Importado!J16
Column F =LEFT(E16,FIND("/",E16)-1)
column G =RIGHT(E16,LEN(E16)-FIND("/",E16))
On most items column E contains something like 2/195.20 and the formula
works great to separate the 2 from the 195.2
But, if Column E happens to contain a number, such as 5, this formula
returns #VALUE for both F and G
How can I get F to return "0" and G to return the value of E ("5" in this
case)?