View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default I wish to fomat numbers in Excel

If you actually want to change the number on entry, rather than format the
number as mentioned in your subject line, then you could use Tools/ Options/
Edit/ Fixed decimal places: Set to -3, but you'll need to remember to put
it back to normal afterwards.
--
David Biddulph

"Rumina" wrote in message
...
so that 0's follow:if I enter 123 then 123000 will enter.