I copied a row containing values and formats, applied what is described and it worked.
Maybe post a sample sheet with what you start from and what you want to accomplish