View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Terri
 
Posts: n/a
Default retain formatting as an actual value

Hello,
I have a cell value formatted as Accounting 0000000000 (10 places). How can
I convert this formatted value to an actual text value? Example: A1 is
actually 2525, but appears as 0000002525. I want to have B1 have an actual
text value of '0000002525.

Thank you!
Terri