| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert ' sign infront of dates
Hi!
i have the current visable values May-06 Jun-06 Jul-06 Aug-06 How do I insert ' (Quote sign) in front of dates in Col A so the underlying values 01/05/2006 01/06/2006 01/07/2006 01/08/2006 becomes the visable values '01/05/2006 '01/06/2006 '01/07/2006 '01/08/2006 Thanks In advance -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200609/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculating number of three month periods between two dates... | Excel Discussion (Misc queries) | |||
| formula to add dates. | Excel Worksheet Functions | |||
| PivotTables - Group Dates, excluding dates | Excel Discussion (Misc queries) | |||
| Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
| 2 digit year in dates return 19xx not 20xx | Excel Discussion (Misc queries) | |||
Threaded Mode
