Thread: three digits
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default three digits
try,

=left(a1,3)

mike

"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
Reply With QuoteReply With Quote