Solved

Show all characters before period

Posted on 2010-08-16
5
480 Views
Last Modified: 2012-05-10
How do I show all the characters before a period?

Exp: 1.19
Output: 1

Exp2: 19.8
Output: 19

Thanks.
0
Comment
Question by:IntercareSupport
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 13

Expert Comment

by:MWGainesJR
ID: 33447888
set the number of decimal places in the number cell formatting to 0.
0
 

Author Comment

by:IntercareSupport
ID: 33447911
I need a formula because I need the literal output of the characters before the period, not a change of view.
0
 
LVL 50

Accepted Solution

by:
barry houdini earned 500 total points
ID: 33447915
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
 

Author Closing Comment

by:IntercareSupport
ID: 33447931
Perfect, thanks!
0
 
LVL 13

Expert Comment

by:MWGainesJR
ID: 33447937
=LEFT(A1,FIND(".",A1,1)-1)
0

Featured Post

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This article describes how to import an Outlook PST file to Office 365 using a third party product to avoid Microsoft's Azure command line tool, saving you time.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question