View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
CLR
 
Posts: n/a
Default Enter a number of 9.75 and have it format as 0.0975

Formatting only changes the way a number appears, it does not perform math on
it. You would need a formula or VBA to do the math. Perhaps if you
explained more about what you are trying to do, someone might could help more.

Vaya con Dios,
Chuck, CABGx3



"Legal Learning" wrote:

and be able to copy that format to many other cells. Using Excel 2003.
--
CLG