enter 5 in 1 cell, show first 3 in other cell
Ryan,
Thanks, good thought but not applicable.
I would be entering a 5 digit zipcode in cell a1, and want the first three
digits
to appear in cell a2
Let me know if you can think of anything.
"Ryan Jones" wrote:
A round about way would be to have it multiply by .01 and then either
convert it to a integer or just have it not show decimals
"JcR" wrote in message
...
I want to be able to:
enter a 5 digit number into in cell a1
have the first 3 digits appear in cell a2
Thanks
|