« UMBS Tidas Buoy Metadata | Main | Logging and communicating file downloads. Part Deux »
November 21, 2011
Convert Date To Text in OpenOffice
This has baffled me many times but not this time. I am revenge.
Melodramatics aside...
This post offers one solution:
1) =TEXT(A1, "YYYY-MM-DD")
2) followed by Paste All -> Text
Except, the output is prepended with an apostrophe. Why?!?!?!?!
I've just managed to do that by pre-formatting the target cell as text and using the dropdown arrow with the Paste icon, selecting "unformatted text".Paste-special would not work because,
1. if I de-select "date & time", nothing is pasted;
2. if I select "date & time", the number value of the date is pasted.You need to have the Paste icon on your toolbar. It has a dropdown list with options which vary according to what is on the clipboard.
Thank you, Noranthon. You are my hero.
Posted by kkwaiser at November 21, 2011 03:09 PM
Trackback Pings
TrackBack URL for this entry:
http://mblog.lib.umich.edu/mt-bin/mt-tb.cgi/2304
Listed below are links to weblogs that reference Convert Date To Text in OpenOffice:
» quick jewels couponcode from couponcode quick jewels
De mooiste sieraden bij QuickJewels met couponcode voor korting! [Read More]
Tracked on September 15, 2012 06:29 AM
» Coerce from Coerce
[Read More]
Tracked on February 11, 2013 06:44 AM
» christian louboutin men shoes from christian louboutin men shoes
Ce site web est vraiment un rendez-vous par le biais de toutes les informations que vous vouliez à ce sujet et ne savait pas à qui demander. Glimpse ici, et vous aurez certainement le découvrir. [Read More]
Tracked on April 4, 2013 03:52 AM
» cheap red bottom shoes from cheap red bottom shoes
Des articles intéressants sur ce genre d'information est une excellente trouvaille. C'est comme trouver un trésor. J'apprécie la fa?on dont vous exprimez vos points et de partager votre point de vue. Merci. [Read More]
Tracked on April 4, 2013 08:09 AM
» polo ralph lauren pas cher from polo ralph lauren pas cher
http://www.boutiquediorfr.biz
http://www.boutiquemonclerdoudounepascher.info
http://www.boutiqueraybanpascher.com
http://www.boutiquesacchanelpascher.com
http://www.chanelpascherenligne.com
http://www.frlongchamppascher2013.com
http://www.louisvu... [Read More]
Tracked on April 5, 2013 11:00 PM
» ray ban pas cher from ray ban pas cher
http://www.boutiquediorfr.biz
http://www.boutiquemonclerdoudounepascher.info
http://www.boutiqueraybanpascher.com
http://www.boutiquesacchanelpascher.com
http://www.chanelpascherenligne.com
http://www.frlongchamppascher2013.com
http://www.louisvu... [Read More]
Tracked on April 5, 2013 11:00 PM
» flyknit trainer nike from flyknit trainer nike
The new Zune browser is surprisingly good, but not as good as the iPod's. It works well, but isn't as fast as Safari, and has a clunkier interface. If you occasionally plan on using the web browser that's not an issue, but if you're planning to browse ... [Read More]
Tracked on April 15, 2013 01:56 AM
» flyknit trainer nike from flyknit trainer nike
Between me and my husband we've owned more MP3 players over the years than I can count, including Sansas, iRivers, iPods (classic & touch), the Ibiza Rhapsody, etc. But, the last few years I've settled down to one line of players. Why? Because I was ha... [Read More]
Tracked on April 16, 2013 09:07 PM
» TRX Training from TRX Training
Understand who's speaking about Buy Trx and also the particular reason why you ought to be worried. [Read More]
Tracked on April 21, 2013 05:56 PM
» OVfPxCvT from OVfPxCvT
Data Discussions: Convert Date To Text in OpenOffice [Read More]
Tracked on April 21, 2013 06:18 PM
» celine bags from celine bags
Data Discussions: Convert Date To Text in OpenOffice [Read More]
Tracked on April 21, 2013 08:02 PM
» miu miu from miu miu
Data Discussions: Convert Date To Text in OpenOffice [Read More]
Tracked on April 21, 2013 09:21 PM
» hermes bags from hermes bags
Data Discussions: Convert Date To Text in OpenOffice [Read More]
Tracked on April 21, 2013 10:28 PM
» seo tools from seo tools
Data Discussions: Convert Date To Text in OpenOffice [Read More]
Tracked on April 22, 2013 06:25 PM
» Michael Kors Handbags from Michael Kors Handbags
Eliminate Air Jordan 11 Concord Pains Permanently [Read More]
Tracked on April 22, 2013 09:13 PM
» sac louis vuitton from sac louis vuitton
Data Discussions: Convert Date To Text in OpenOffice [Read More]
Tracked on April 24, 2013 10:20 AM
» burberry bags from burberry bags
Data Discussions: Convert Date To Text in OpenOffice [Read More]
Tracked on April 25, 2013 03:57 AM
» Nike Blazer from Nike Blazer
Following the Nike store headline the second most go through section of each and every product sales letter will be the PS, or perhaps the postscript. Nike Free Run This is the... [Read More]
Tracked on April 27, 2013 12:41 PM
» Nike Blazer vintage from Nike Blazer vintage
In recent times, his brand has faced adversity from numerous offshore rivals possessing the expertise, resources and skill Nike Free run to offer similarly intricate, beautiful and expertly crafted luxury goth... [Read More]
Tracked on April 28, 2013 05:12 AM
» mulberry bags from mulberry bags
Data Discussions: Convert Date To Text in OpenOffice [Read More]
Tracked on April 29, 2013 02:49 AM
» nike flyknit from nike flyknit
The new Zune browser is surprisingly good, but not as good as the iPod's. It works well, but isn't as fast as Safari, and has a clunkier interface. If you occasionally plan on using the web browser that's not an issue, but if you're planning to browse ... [Read More]
Tracked on May 1, 2013 01:21 AM
» wow gold from wow gold
Data Discussions: Convert Date To Text in OpenOffice [Read More]
Tracked on May 4, 2013 08:29 PM
» louis vuitton bags from louis vuitton bags
Data Discussions: Convert Date To Text in OpenOffice [Read More]
Tracked on May 6, 2013 12:40 AM
» nike france from nike france
Data Discussions: Convert Date To Text in OpenOffice [Read More]
Tracked on May 13, 2013 06:13 AM
» LOUIS VUITTON REPLICA from LOUIS VUITTON REPLICA
Data Discussions: Convert Date To Text in OpenOffice [Read More]
Tracked on May 13, 2013 06:13 AM
» ahappydeal cheap wrist wat from ahappydeal cheap wrist wat
Data Discussions: Convert Date To Text in OpenOffice [Read More]
Tracked on May 14, 2013 09:38 AM
» ugg boots from ugg boots
There is no royal road to science, and only those who do not dread the [Read More]
Tracked on May 14, 2013 10:43 PM
» coach bags from coach bags
Data Discussions: Convert Date To Text in OpenOffice [Read More]
Tracked on May 19, 2013 07:02 PM
» cheap louis vuitton bags from cheap louis vuitton bags
Data Discussions: Convert Date To Text in OpenOffice [Read More]
Tracked on May 19, 2013 07:02 PM
» PIG from PIG
Data Discussions: Convert Date To Text in OpenOffice [Read More]
Tracked on May 19, 2013 07:02 PM
» ルイヴィトン from ルイヴィトン
Data Discussions: Convert Date To Text in OpenOffice [Read More]
Tracked on May 20, 2013 03:28 PM