Thread
:
three digits
View Single Post
#
2
Posted to microsoft.public.excel.misc
Jacob Skaria
external usenet poster
Posts: 8,520
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
Reply With Quote
Jacob Skaria
View Public Profile
Find all posts by Jacob Skaria