I am having a problem formatting cells to currency. What happens is this - I have to format them twice, because the first time I format them it will automatically set them to "number" and not currency, even though I choose currency originally. These are on unformatted cells to begin with and also on cells that are formatted to currency when I want to change the decimal spaces.

Does anyone know why this happens and how to stop it? Thanks!