How to prevent rounding

Copper Contributor

In my excel worksheet I need to insert values with "leading zeros" for example 0.07%. When I insert the value it is rounded to zero, how do I prevent this?

1 Reply

@rodzangelina 

That is not the standard behaviour. You probably changed something in the options or in the cell formatting.