How to prevent rounding

%3CLINGO-SUB%20id%3D%22lingo-sub-2878030%22%20slang%3D%22en-US%22%3EHow%20to%20prevent%20rounding%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2878030%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20my%20excel%20worksheet%20I%20need%20to%20insert%20values%20with%20%22leading%20zeros%22%20for%20example%200.07%25.%20When%20I%20insert%20the%20value%20it%20is%20rounded%20to%20zero%2C%20how%20do%20I%20prevent%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2878030%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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.