Share via

zero Remove After Decimal Point

Anonymous
2020-01-04T10:13:38+00:00

My Excel Sheet contain in Days Column

    Days

     1.50

     1.00

     2.00

     6.00

i should Remove zero after whole Number and remain keep Decimal point. like that  Reslut Below

Days

 1.50

 1

 2 

 6

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

5 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  2. Anonymous
    2020-01-06T13:18:31+00:00

    That would be a very bizare, and inconsistant method of formating, either its two decimal points or it is none

    Results will be.

    1.50

    1

    2

    6

    keep decimal point and Remaining Whole number end with Zero to be Removed 

    sir, i find it ..

    =SUBSTITUTE(TRIM(SUBSTITUTE(AL5,"."," "))," ",".")

    Was this answer helpful?

    0 comments
  3. Anonymous
    2020-01-06T07:48:13+00:00

    That would be a very bizare, and inconsistant method of formating, either its two decimal points or it is none

    Results will be.

    1.50

    1

    2

    6

    keep decimal point and Remaining Whole number end with Zero to be Removed

    Was this answer helpful?

    0 comments
  4. Anonymous
    2020-01-04T18:40:12+00:00

    < deleted >

    Was this answer helpful?

    0 comments
  5. Anonymous
    2020-01-04T18:29:04+00:00

    That would be a very bizare, and inconsistant method of formating, either its two decimal points or it is none

    Was this answer helpful?

    0 comments