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
format the number thats showing as xxxx+Exxx, as a number zero decimal places - make sure the column is wide enough to display the number
To remove the Time from a date
in a new cell just use
INT( cell with the Date&Time)
Date is a number (the number of days ) from 0 Jan 1900
Time is the fraction part of that number for 0 to 24:00
INT() removed the fraction part and just leaves a number with NO decimals - so NO time
Last edited by etaf; 06-06-2021 at 11:24 AM.
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Ah! Thank you so very much with Int function
I have another question related to my second query.
Even if I check my column width and adjust it, it still shows with this format xxxx+Exxx [in my office computer only] and when I do cell formatting with number, it add 0000 at the end which I do not want. It also add random number at the end but not the actual number.
Please suggest.
Thank you
strange,
it worked on my PC with your example
Scientic notation = X.xxxxxx +EXXX
change to number format - NO decimal spaces
See F23 to F33 & G23 to G:33
Thank you Sir!!
I will try to follow the same as you suggested tomorrow with my office computer.
I really thank you for your help
Warm Regards,
Manish
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks