View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default Number Format: Convert No. to thousands

OR if you are looking at converting while you enter the numbers then..

ToolsOptionsEditcheck 'Fixed decimal' and adjust 'Places' to minus 3 (-3)
Now try entering 1253...

--
Jacob


"Faraz A. Qureshi" wrote:

Any idea, how to convert an entry of 2,153 be displayed/converted to
2,153,000, i.e. zeros' format?
--
Thanx in advance,
Best Regards,

Faraz