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!

Show DateValue as Text not decimel
 

The value actuall IS 38692.5869097222. That behaves the same way as when you
entery 50% in a cell and then copy/paste values: the pasted value is not
50%, but 0.5 which is the value of the cell.

Try this:
A1: (any date)
B1: =TEXT(A1,"yyyymmddhhmmss")

You can Copy/Paste Special:Values that formula.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Kathy S" wrote:

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!