« 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?!?!?!?!

Winner!!

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:

» meta keywords from meta keywords
What should I do to get rid of the blockage of video on youtube due to copyright content? [Read More]

Tracked on February 7, 2014 02:50 PM

» well nanoo from well nanoo
What is the best way to search for blogs you are interested in? [Read More]

Tracked on February 9, 2014 10:44 AM

» cleaning wood flooring tips from cleaning wood flooring tips
How come my computer does not register the other computers in the network? [Read More]

Tracked on February 11, 2014 04:03 AM

» the venus factor video from the venus factor video
Data Discussions: Convert Date To Text in OpenOffice [Read More]

Tracked on February 13, 2014 04:52 AM

» best seo company from best seo company
data discussions: convert date to text in openoffice [Read More]

Tracked on February 16, 2014 09:25 PM

» Woolrich Outlet from Woolrich Outlet
Quei giovani sono una ventata di aria fresca. Moriva 30 anni fa, in una tiepida notte parigina [Read More]

Tracked on February 17, 2014 08:13 PM

» Canada Goose from Canada Goose
nance ses popos en mettant t s [Read More]

Tracked on February 17, 2014 08:40 PM

» como adelgazar en una semana from como adelgazar en una semana
como adelgazar rapido [Read More]

Tracked on February 18, 2014 08:15 PM

» replica hublot watch from replica hublot watch
Data Discussions: Convert Date To Text in OpenOffice [Read More]

Tracked on February 19, 2014 03:30 PM

» www.coachfactory-outletonline.com from www.coachfactory-outletonline.com
prada outlet prada handbags prada shoes http://www.pradaoutletsite.comhttp://www.pradaoutletsite.com [Read More]

Tracked on February 20, 2014 03:43 PM

» divorce attorney around will county illinois from divorce attorney around will county illinois
What is your opinion of personal blogs and online journaling? [Read More]

Tracked on February 23, 2014 07:09 AM

» gold investing from gold investing
How to use mozila firefox seting from an other windows? [Read More]

Tracked on February 23, 2014 09:44 AM

» Driving Lessons Dalkey from Driving Lessons Dalkey
Sign up form for Joomla without all the bells and whistles? [Read More]

Tracked on February 24, 2014 07:13 AM

» teeth whitening dublin from teeth whitening dublin
I want to change my Blogger/Blogspot background into a picture I want instead of the ugly plain ones that provide you with.. . I tried looking up on google how to change it but it only came up with how to change the background with the old Blogger. . .... [Read More]

Tracked on February 25, 2014 08:41 AM

» local online marketing from local online marketing
How do you start your own website to advertise your new business? [Read More]

Tracked on February 25, 2014 09:22 AM

» supplies from supplies
How do I convert my website from dreamweaver to wordpress? [Read More]

Tracked on February 26, 2014 05:00 AM

» online marketing los angeles from online marketing los angeles
Never considered it that way. [Read More]

Tracked on February 26, 2014 05:46 AM

» ディーゼル 時計 新作 from ディーゼル 時計 新作
All I hear is a bunch of whining about one thing that you could possibly repair if you happen to werent too busy on the lookout for attention. [Read More]

Tracked on February 28, 2014 10:49 PM

» All Euro Garage from All Euro Garage
Data Discussions: Convert Date To Text in OpenOffice [Read More]

Tracked on March 1, 2014 02:56 AM

» roth ira vs traditional ira from roth ira vs traditional ira
Presumably the magazine doesn't do deals with each source that it reproduces, so how does copyright law allow them to re-print editorial content that they don't own without paying royalties?. . Also, can this law be applied internationally?. [Read More]

Tracked on March 1, 2014 06:05 PM

» my sources from my sources
I had two computers both connected to a wireless router. Yesterday I connected a third computer to the network and, although the connection goes through for this new computer, one of the original computers now says "Limited or no connectivity" and cann... [Read More]

Tracked on March 1, 2014 07:57 PM

» credit fraud cases from credit fraud cases
My partner is making a template in dreamweaver for joomla site and we are not to sure on how to upload it to it. We appreciate the help, thanks in advance.. [Read More]

Tracked on March 2, 2014 07:27 PM

» www.igetdoc.com from www.igetdoc.com
Data Discussions: Convert Date To Text in OpenOffice [Read More]

Tracked on March 7, 2014 09:43 AM

» structured settlements calculator from structured settlements calculator
I have a school project for my creative writing class that requires a writing portfolio, but I have no clue how to make one. I never really understood what a portfolio was. If someone could help out, it'd be wonderful.. [Read More]

Tracked on March 7, 2014 10:32 AM

» payday loans from payday loans
Hi, I just discovered your site through Google. Your post is truly relevant to my life right now, and I am definitely satisfied I came across your blog. [Read More]

Tracked on March 7, 2014 02:20 PM

» Payday Loans Online from Payday Loans Online
Do you people have a facebook fan page? I looked for one on twitter but could not discover one, I would really like to become a fan! [Read More]

Tracked on March 10, 2014 09:28 AM

» http://www.cheftubetv.com/users/MEwers from http://www.cheftubetv.com/users/MEwers
Data Discussions: Convert Date To Text in OpenOffice [Read More]

Tracked on March 11, 2014 12:54 AM

» Handverkere from Handverkere
Data Discussions: Convert Date To Text in OpenOffice [Read More]

Tracked on March 14, 2014 08:42 PM

» pizza hut coupon from pizza hut coupon
What computer software were computers using before Microsoft was invented? [Read More]

Tracked on March 15, 2014 02:35 AM

» read this post here from read this post here
How can I prevent my blogspot from showing up in search engines? [Read More]

Tracked on March 22, 2014 08:19 AM

» seo hbos card services cardiff from seo hbos card services cardiff
I would like to start a jobs website using Joomla or Wordpress. Is this possible? [Read More]

Tracked on March 22, 2014 10:27 AM

» learn more here from learn more here
I know that there are countless plug-ins designed to make the comments do-follow, but I'm looking for something that will make the links in the blog-posts themselves do-follow. Please include a link or detailed instructions on how to do this. Thanks!.... [Read More]

Tracked on March 24, 2014 06:22 AM

» cheap michael kors bags from cheap michael kors bags
Data Discussions: Convert Date To Text in OpenOffice [Read More]

Tracked on March 28, 2014 12:36 AM

» Baddel Blog from Baddel Blog
I have a wordpress blog now, but I can't figure out how to get readers into there! I have been using myspace and it's been great, subscriptions like crazy, but a lot of them don't have wordpress...so no leads there. Besides, I am posting the same inf... [Read More]

Tracked on March 29, 2014 06:30 PM

» business owners policy from business owners policy
I'm not great with html, but I think there's a simple way to add a byline to the beginning of my blog posts under the title. Is there anywhere I can find a step-by-step guide on how to do this?. The blog is set up on Wordpress, and is using the pilcro... [Read More]

Tracked on March 30, 2014 08:29 PM

» website design companys from website design companys
get top quality acesef work available [Read More]

Tracked on March 31, 2014 02:40 PM

» www.carinsurance.theclevergroup.com/ from www.carinsurance.theclevergroup.com/
How I Can make my article copyright marked?Who is authorized agency for copyright articles? [Read More]

Tracked on April 2, 2014 11:21 AM

» dog arthritis medicine from dog arthritis medicine
go here for greatest arthritis in dogs available [Read More]

Tracked on April 4, 2014 10:12 AM

» http://dev.seedthecommunity.org/ from http://dev.seedthecommunity.org/
Data Discussions: Convert Date To Text in OpenOffice [Read More]

Tracked on April 6, 2014 05:51 AM

» www.8108m.com from www.8108m.com
Data Discussions: Convert Date To Text in OpenOffice [Read More]

Tracked on April 6, 2014 09:20 AM

» sr22 from sr22
How to create own radio streaming and add the radio into my blogspot? can you give me step by step? [Read More]

Tracked on April 10, 2014 11:47 PM

» seovolución from seovolución
Can I install a different Wordpress theme to a Wordpress hosted blog? [Read More]

Tracked on April 12, 2014 07:05 PM

» small business insurance quote from small business insurance quote
not including myspace and facebooke and that where blogging is just an instalment.. More like blogger. Which one is used the most and reaches the highest amount of people?. [Read More]

Tracked on April 14, 2014 04:28 PM

» arthritis dog from arthritis dog
The greatest dog arthritis treatment anywhere [Read More]

Tracked on April 16, 2014 02:07 PM

Comments

Login to leave a comment. Create a new account.