Solved

Show all characters before period

Posted on 2010-08-16
5
460 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
  • 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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa‚Ķ

776 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