Solved

looking for a formula

Posted on 2014-09-05
3
82 Views
Last Modified: 2014-09-05
is there a formula that will allow me to exclude the first number to the left of the decimal point.

i.e.

Actual Number             Required  Number

123456.78                   12345.00
987654.32                   98765.00
123.45                         12.00

Possible ??

Thanks in advance
0
Comment
Question by:Jagwarman
3 Comments
 
LVL 37

Accepted Solution

by:
Neil Russell earned 500 total points
ID: 40305418
=INT(12345.6/10)
will give 1234
0
 

Author Closing Comment

by:Jagwarman
ID: 40305471
thanks
0
 
LVL 19

Expert Comment

by:helpfinder
ID: 40305475
if you have the same logic for all your values (2 decimal places) the  you can use
=LEFT(A5;LEN(A5)-4)
assume your orignal value is in cell A5

PS: please notice that you may need to replace semicolon (;) in the formula by comma (,) based on your Regional settings
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

Suggested Solutions

How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

786 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