I am trying to do a mortgage file and i want a number to be entered as 100 but display 100,000 but all in the same cell. Obv. i can have one cell to be 100 and another to be =(cell)*100000 but can i make this happen in one cell. Basically is there a cell format that will multiply the input by a certain value?? Thanks.