Thread: Getting the first 3 digits out of 6 digit cells?
View Single Post
  #5   Report Post  
Dave Peterson
 
Posts: n/a
Default
One mo

=INT(A1/1000)



Darla wrote:

I have a 6 digit number in a cell. I want the first 3 digits of it to appear
in another cell. What is the formula?

--

Dave Peterson
Reply With QuoteReply With Quote