Treating text as zero in Excel

Let’s say you are getting inputs you can’t control and in some cases you get text and others you get numbers. You want the numbers, but you need to treat text as zero. Here’s the easy way to do that. There is a little used function in Excel called N. It converts text into a … Continue reading Treating text as zero in Excel