Hi Experts,
Please may I know how to convert XXXX.0YYY to XXXX.YYY (only if there is 0 after decimal else ignore)
Example
123.01 to 123.1
23.0534 to 23.534
23.23 to 23.23
Thanks a ton.
Hi Experts,
Please may I know how to convert XXXX.0YYY to XXXX.YYY (only if there is 0 after decimal else ignore)
Example
123.01 to 123.1
23.0534 to 23.534
23.23 to 23.23
Thanks a ton.
If A1 is number
Try
=IF(MOD(A1,1)*10<1,INT(A1)+MOD(A1,1)*10,A1)
Quang PT
Hi @bebo021999
Thank you and Brilliant!
I wish I understand the logic, I have subscribed to the link.
Thanks a ton
Another way:
=SUBSTITUTE(A1,".0",".")
Yeah, this is easy, I am so dumb. Thank you for confirming
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks