View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kathy S
 
Posts: n/a
Default Show DateValue as Text not decimel

I have a datevalue [12/6/2005 2:05:09 PM] formatted as yyyymmddhhmmss
[20051206140738]. I want that 'value' [20051206140738] as text,...not it's
counterpart text value [38692.5869097222] to show in a cell. If I say paste
value it puts in the counterpart value. HELP!