Show all characters before period

How do I show all the characters before a period?

Exp: 1.19
Output: 1

Exp2: 19.8
Output: 19

Thanks.
IntercareSupportAsked:
Who is Participating?
 
barry houdiniConnect With a Mentor Commented:
MWGaines suggestion works by altering the display but the underlying value of the cell won't change. If you want to extract the value into another cell try
=INT(A1)
where your data is in A1
regards, barry
0
 
MWGainesJRCommented:
set the number of decimal places in the number cell formatting to 0.
0
 
IntercareSupportAuthor Commented:
I need a formula because I need the literal output of the characters before the period, not a change of view.
0
 
IntercareSupportAuthor Commented:
Perfect, thanks!
0
 
MWGainesJRCommented:
=LEFT(A1,FIND(".",A1,1)-1)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.