View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dberger16 dberger16 is offline
external usenet poster
 
Posts: 11
Default wrong number, no currency format

each time i enter a number in a worksheet such as 5, it shows up as .05.
also, i cannot get my worksheet to format the cells in currency without
pressing the $ icon. thank you.
--
DaveB