Results 1 to 5 of 5

How to remove time from date in a cell. How to get complete number without exponential

Threaded View

  1. 06-06-2021, 11:14 AM #1
    Pawnar
    Pawnar is offline
    Registered User
    Join Date
    02-07-2019
    Location
    New Delhi
    MS-Off Ver
    2010
    Posts
    80

    How to remove time from date in a cell. How to get complete number without exponential

    Hello Sir/Ma'am,

    I'm facing issue while removing the time that is coming with the date in a cell. I did format but my leader says that time still shows in the formula bar.

    The second query is that, I'm not getting the original number. Its a very large ID but coming with exponential. I did format cell but result is not coming.

    I have attached the file for your review.

    Thank you.

    Manish
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Solving Complex formula w/ Exponential & Exponential w/ Imaginary number
    By x5bulldog in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-03-2020, 08:56 PM
  2. How to remove time stamp from cell with date
    By rayman741 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-05-2019, 02:40 PM
  3. Need to remove letter from 15 digit number w/out it converting to exponential format More!
    By carlthebruce in forum Excel General
    Replies: 9
    Last Post: 02-12-2015, 01:52 AM
  4. Help please how to remove a line if cell = complete to a new page
    By bjr6666 in forum Excel General
    Replies: 3
    Last Post: 10-07-2014, 12:45 PM
  5. Count number of instances complete in a certain time
    By Trending in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-23-2014, 04:12 AM
  6. How do I remove the time from a cell with Date and Time in it?
    By templa in forum Excel General
    Replies: 3
    Last Post: 04-22-2009, 11:49 AM
  7. [SOLVED] excel converts date/time value to exponential value
    By [email protected] in forum Excel General
    Replies: 3
    Last Post: 06-06-2006, 08:10 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1