View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
user user is offline
external usenet poster
 
Posts: 44
Default Display cell value

can anyone help me out with the option to set the cell value as below
EG;- 450.00
252.12
500.00
these are the values with decimal points 450.00 but in the formula bar i.e
at fx it will be displayed as 450 without any decimal point.
i want some option wherein the value in the cell and the formula bar to
display as 450.00 only