| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I get excel to show ALL lines of wrapped text? | Excel Worksheet Functions | |||
| Using Concatenate function to generate text in Text Box | Charts and Charting in Excel | |||
| dates and text | Excel Discussion (Misc queries) | |||
| trying to match more than 1 text value in a row to show end value | Excel Worksheet Functions | |||
| show text after formulas | Excel Discussion (Misc queries) | |||
Linear Mode
