ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Cell Format (https://www.excelbanter.com/excel-discussion-misc-queries/43338-cell-format.html)

Mike R

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

Peo Sjoblom

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