Decimal separator

[Inactive User]

Hi Team,

Need a formula to separate this integer as "000000067460" and "0000" wherein decimal as separator. Kindly advice.

Regards,

Guru 

[Emil_Kos · Accepted solution]

Hi,

Maybe you can use text to columns and "." as a seperator? 

[OllieClarke · Accepted solution]

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

[Inactive User]

Thanks so much ! that logic works....

[SiddeshDhruva]

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:

Spend number	Decimal Value	Scenario 1(Nearest "0")	Scenario 2, Nearest 10	Scenario 3, Nearest 100
141.34	0.34	141	140	100

please suggest

Thank you!