Limit returned value to last digit

[Patrick C. Simonds]

In cell A4 is a 4 digit number in cell A1 I want only the last number

 

[Bob Phillips]

=IF(ISNUMBER(A4),IF(LEN(A4)=4,RIGHT(A4),""),"")

 

[Sean Timmons]

=RIGHT(A4,1)

 

[ShaneDevenshire]

Hi,

And a little shorter:

=RIGHT(A1)

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