All Posts by n.ashutosh

Add Specific number of zeros to a value

This is one of the finest forumlae I’ve ever seen. Check this post at MrExcel. If you want to have a value specific number of digits otherwise add zeros in front of it, this formula could be used: =TEXT(A1,REPT(“0”,n)) where n is the number of digits you want. So 4555 becomes 000004555 with formula =TEXT(4555,REPT(“0”,9))

Continue reading

2 Change references

If you want to change references of a formula, you could toggle F4 key inside the formula to change the references from Absolute, Column Absolute Row Absolute or all relative. Although, if you have to change references from a range, you can use these two options1. Download ASAP utilities, because it’s worth it, they have […]

Continue reading
1 13 14 15 16 17 22