Thread: help with removing digits from a number
View Single Post
  #2   Report Post  
JE McGimpsey
 
Posts: n/a
Default
One way:

=ROUND(A1,-4)

In article ,
"frank" wrote:

I have a column with 15 digit numbers. I need to remove the last four digits
from all of them. Is there a quick way to do this?
Reply With QuoteReply With Quote