I have a form that my company has made up and is almost totally useless. I have recreated most of it to look like there form so they can not tell mine from there?s
what I don?t know how to do are 2 things, first question in a numeric cell that looks like this $ – it stays that way until a value is put in elsewhere then it looks like this $ 100.00 the dollar sign stays on the left side of the cell no matter what number in. How do you format a cell to do that?
Second question (its dumb I should know how to do it but cant figure it out) certain cells are locked so I cannot see the formula or edit them in any way, how do you lock just certain cells, some of the cells I need because I have to enter data in them but others I don?t want anyone messing with.
Thanks in advance