Hi Team,
Need a formula to separate this integer as "000000067460" and "0000" wherein decimal as separator. Kindly advice.
Regards,
Guru
Hi,
Maybe you can use text to columns and "." as a seperator?
Hi @Inactive User
I'm not sure I fully understand, but if you have a string and want to split the decimal and numeral then you can use a text to columns tool delimiting on '.'
Hope that helps
Thanks so much ! that logic works....
Hi, I am looking for a similar solution but in a different output, i want to split my data as below
1, Decimal value
2, Scenario 1 - Nearest "0"
3, Scenario 2 - Nearest "10"
4, Scenario 3 - Nearest "100"
below is the example:
please suggest
Thank you!
