Den 2011-02-01 17:13:10 skrev . <[email protected]>:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
How do I get Calc to put any year (listed in cell A1) and the month
(listed in B1) into C1 so that it would look like this; January 2011
Please don't reply unless you know exactly how to do it.
In A1, you have, for example, 2011 and in B1 the text ”January”, is that
the starting point of this problem?
If so, type this into C1:
=B1 & " " & A1
Is B1 rather a number, like 1 for January or 9 for September? Then do the
following:
In C1, enter the following:
=DATE(A1,B1,1)
Right click C1 → Format cells… → Numbers → Enter the following into the
Format description field:
MMMM YYYY
Click OK.
I have Swedish OpenOffice.org, so things might be named differently than
the above description, so you probably need to use your imagination a bit,
perhaps…
--
Kind regards
Johnny Rosenberg
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
