splitting numbers in a cell

Copper Contributor

2.45 in cell subtracked 1 in next cell

1 Reply

@stephen800lostman 

With 2.45 in A2, the formukla =A2-1 will subtract 1 from 2.45 and return 1.45

If that is not what you intended, can you explain what you want in more detail?