![]() |
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 |
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 |
All times are GMT +1. The time now is 03:46 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com