Thread: three digits
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default three digits

A1 = 5 digit number
=value(LEFT(A1,3))

If this post helps click Yes
---------------
Jacob Skaria


"MFS" wrote:

I have some cells that have five digits, I want to take only the first three
digits.
pleas can you help me?

--
MFS22