View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jazzydwit
 
Posts: n/a
Default formatting number value to text value in excel

Hi.
I am trying to contain a number value in excel after changing the value
to text.
First, I calculate a cell, then change that cell from a formula to a
value. Then, I want to change the value to a number with 2 digits
after the decimal. My dilemma occurs when the number value shows as 3
digits after the decimal. When I try to reformat for 2 digits, the
number value is displayed with 3 digits. Does that make sense? Please
help!