Results 1 to 10 of 10

Display only the number from left of decimal point.

Threaded View

  1. #1
    Registered User
    Join Date
    11-12-2007
    Posts
    16

    Display only the number from left of decimal point.

    Hello,
    I want to display only the number from the left of the decimal point from a scientific notation number. Example:

    Cell A1:
    1.834E10 Cell B1: 1 Answer

    7.123E-12 Cell B1: 7 Answer

    3.792E38 Cell B1: 3 Answer

    Which ever scientific notation I enter in Cell A1, The formula in Cell B1 will only display the left most digit from the decimal point.

    I tried using the Left function and it work, however when I want to use that number in Cell B1 into another formula it did not work because that number is consider as a text not a number. So the Left function is not the one to use.

    So how do I write that formula in Cell B1 to display the left most digit from the decimal point from a scientific notation number in Cell A1 and still be a number and not a text?

    Sincerely,
    Arthur
    Last edited by arthurz11; 10-28-2011 at 06:51 PM. Reason: The number were too close and had to retype Cell B1

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1