Thread: Using RIGHT function to get right-most digit for each cell in acolumn
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein \(MVP - VB\)[_1777_] Rick Rothstein \(MVP - VB\)[_1777_] is offline
external usenet poster
  
Posts: 1
Default Using RIGHT function to get right-most digit for each cell in a column
If all your values in the column are numeric, then you probably want this...

=--RIGHT(A1)

If there can be non-numeric data in your columns, then you probably want
this instead...

=IF(ISNUMBER(A1),--RIGHT(A1),"")

Rick


"Sheldon Potolsky" wrote in message
...
Without looping, in VBA, how would I take each numeric value in column
A and change it's value to get only the right-most digit?
Thanks,
Sheldon

Reply With QuoteReply With Quote