Do tools>options>edit and select fixed decimal places, put it to -3.
Don't forget to uncheck it after you are done. If you need to enter smaller
numbers,
just put a period after the number and it won't change so if you want to
type 100,
enter it as 100. otherwise it will be 100000
--
Regards,
Peo Sjoblom
"tarynnl" <tarynnl.wfgsz...excelforum-nospam.com> wrote in message
news:tarynnl.wfgsz...excelforum-nospam.com...
> I want to be able to type in a value e.g. 10 and excel automatically
> adds zeros to the end of the value to make it 10000, so when i type in
> 20 it automatically changes it to 20000
>
> ---
> ~~ Message posted from
http://www.ExcelTip.com/> ~~View and post usenet messages directly from
http://www.ExcelForum.com/>
peo
| Thu, 22 May 2008 05:41:00 GMT |