Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Cell Format
I would like to be able to enter 150 and have it read and be able to
calculate 150,000. I have a sheet set up with the costs of homes that are for sale. I am looking to do some "what if" and would like to not have to enter the last three zeros. Just trying to get good at being lazy :-). Thanks for the help!!! Mike |
#2
|
|||
|
|||
Toolsoptionsedit and set fixed decimal places to -3
note that this will change other workbooks as well so turn it off when you don't need it, another option would be an event macro that will mulply all values with 1000 -- Regards, Peo Sjoblom (No private emails please) "Mike R" wrote in message ... I would like to be able to enter 150 and have it read and be able to calculate 150,000. I have a sheet set up with the costs of homes that are for sale. I am looking to do some "what if" and would like to not have to enter the last three zeros. Just trying to get good at being lazy :-). Thanks for the help!!! Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why does my format keep changing in the cell? | Excel Discussion (Misc queries) | |||
how do I format a cell reference to move as source changes | Excel Worksheet Functions | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Show Blank is cell value=0 but count as a zero in sum. How to format this cell ? | Excel Worksheet Functions | |||
How do I unhide the cell format function in Excel 2000 | Excel Worksheet Functions |