Show DateValue as Text not decimel

K

Kathy S

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!
 
R

Ron Coderre

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
 
Top