Limit returned value to last digit

  • Thread starter Thread starter Patrick C. Simonds
  • Start date Start date
Hi,

And a little shorter:

=RIGHT(A1)

1 is the default value and you don't neet to enter it.
 

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

Similar Threads

Limit returned value 5
counting digits, not numbers 4
How to concatenate 3064 and 01 with 306401 as a result? 11
SUMPRODUCT formula I think w/ wild card & number vs number as text 8
Zip Code Last 4 Digit as Zero 1
Limitations on Sumif Calculation 3
Calculations 1
How to set the formula? 4

Back
Top