So I need to change how my data is formatted and i don't really know how to do it. The data I have is volume and some of it is in millions and some in billions. An example of how it looks is 100M or 100B. I need my data to be in number form, e.g. 100,000,000 or 100,000,000,00. I have found methods online of going from number form to letter form, but I can't find a method of how to go from letter form to number form and don't really know enough about excel to be able to 'reverse' the methods I've found online. If anyone could help, it would be greatly appreciated.