| 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! |
| 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) | |||
Threaded Mode
