View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph David Biddulph is offline
external usenet poster
 
Posts: 618
Default If a range of cells in Excel are formatted as dates ie. (mm/dd/yy)

"mfoley" wrote in message
...
....
Also, if a cell is formatted with two decimal places I should not have to
enter the decimal point.

....

Tools/ Options/ Edit/ Fixed Decimal Places
--
David Biddulph