Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 492
  • Last Modified:

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.
0
IntercareSupport
Asked:
IntercareSupport
  • 2
  • 2
1 Solution
 
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
 
barry houdiniCommented:
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
 
IntercareSupportAuthor Commented:
Perfect, thanks!
0
 
MWGainesJRCommented:
=LEFT(A1,FIND(".",A1,1)-1)
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now