Ten Key Calculator cell format

M

Manny Torres

Is there a way to format a cell to move the decimal back
two spaces similar to a ten key adding machine. In
example, if I key 1025 in a cell can a custom format make
that value 10.25.

Other examples:

Enter Format
10 .10
456 4.56
2000 20.00

Thanks in advance for anyone who could help me with this.

Manny
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top