Show all characters before period

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

Question by:IntercareSupport
  • 2
  • 2
LVL 13

Expert Comment

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

Author Comment

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

Accepted Solution

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
where your data is in A1
regards, barry

Author Closing Comment

ID: 33447931
Perfect, thanks!
LVL 13

Expert Comment

ID: 33447937

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