trailing zeros

k78=$608.60

len(k78)=5

i would like to see the trailing zero and the result would be a length of 6. i need this to do some other calculations

Originally Posted by htorres

k78=$608.60

len(k78)=5

i would like to see the trailing zero and the result would be a length of 6. i need this to do some other calculations

=LEN(K78)+1

Format the cell to Currency with the number of decimal places you desire.

Try this:

=LEN(TEXT(K78,"0.00"))

that worked great, thanks for your help.