Excel ?s

[David]

My wife is doing her on-line class and she is working in excel. She does not know how to enter $19,200,000 into excel as $19.2 so that the math would work properly. She will be timing the 19.2 by 1% and having excel work out the math. Anyone with experience?

[Blood Asp]

you can do it but i can't remember how without actually looking at excel (which i dont have) Doh... It should be somewhere on the decimel things on the Numbers option... (i think)

[Hermskii]

No time but right click on cell. Select format cells. Choose the numbers options. Figure it out from there. Sorry in hurry.

[bobster]

Not sure if i understood the question correctly, but multiply 19.2 (or whatever is entered) by 1,000,000 to get 19,200,000.

[David]

The question was something to the effect of; what is the amount a person gets if the person gets 1% of $19.2 million. I can do the math but the issue is that it is supposed to be done in Excel. She wants to display the $19.2 million as shown instead of the $19,200,000 in which would be easiest format for the cell for the formula. So my question is trying to format the cell so that 19,200,000 would show as 19.2 million.

[Hook]

I would check the scroll down menu for formatting numbers.
BUT - you MAY have to do a "Rounding" of the number.
(XL isn't in front of me at the moment but I know you CAN round numbers.)

[Hermskii]

Is this done yet> I don't want to do it if we don't need it. I have time now. but my first answer pretty much was right I think.

[David]

Is this done yet> I don't want to do it if we don't need it. I have time now. but my first answer pretty much was right I think.

Well what my wife did was to state that the amount is millions and used decimals points for the amounts. Thanks anyways.