|
| View previous topic :: View next topic |
| Author |
Message |
rod
Guest
|
 Posted: Sat Dec 22, 2007 1:23 pm Post subject: Date to text: |
 |
|
| Can I process date 12/3/2007 to year/month "200703" etc in another field? |
|
| Back to top |
|
 |
Google
Sponsor
|
| Posted: Sat Dec 22, 2007 1:23 pm Post subject: Advertisement |
|
|
|
|
| Back to top |
|
|
Michael Santovec
Guest
|
| Posted: Sat Dec 22, 2007 8:47 pm Post subject: Re: Date to text: |
|
|
If you are using the spreadsheet, with the date in cell A1 and in date
format (not a text string) this should do what you want
=STRING(YEAR(A1)+1900,0)&IF(MONTH(A1)<10,"0","")&STRING(MONTH(A1),0)
--
Mike - http://pages.prodigy.net/michael_santovec/techhelp.htm
"rod" <pookiethai@NOSPAMiprimus.com.au> wrote in message
news:eSatm3JRIHA.5400@TK2MSFTNGP04.phx.gbl...
| Quote: | Can I process date 12/3/2007 to year/month "200703" etc in another
field?
|
|
|
| Back to top |
|
|
rod
Guest
|
| Posted: Sun Dec 23, 2007 12:22 am Post subject: Re: Date to text: |
|
|
There are no "fields" in a spreadsheet Mike.
I'll give it a go with adaption.
Thanks very much for addressing my query.
Rod.
"Michael Santovec" <michael_santovec@prodigy.net> wrote in message
news:euwlTvNRIHA.3516@TK2MSFTNGP02.phx.gbl...
| Quote: | If you are using the spreadsheet, with the date in cell A1 and in date
format (not a text string) this should do what you want
=STRING(YEAR(A1)+1900,0)&IF(MONTH(A1)<10,"0","")&STRING(MONTH(A1),0)
--
Mike - http://pages.prodigy.net/michael_santovec/techhelp.htm
"rod" <pookiethai@NOSPAMiprimus.com.au> wrote in message
news:eSatm3JRIHA.5400@TK2MSFTNGP04.phx.gbl...
Can I process date 12/3/2007 to year/month "200703" etc in another
field?
|
|
|
| Back to top |
|
|
rod
Guest
|
| Posted: Sun Dec 23, 2007 12:25 am Post subject: Re: Date to text: |
|
|
Worked like a charm, again, thanks very much.
"Michael Santovec" <michael_santovec@prodigy.net>
wrote in message news:euwlTvNRIHA.3516@TK2MSFTNGP02.phx.gbl...
| Quote: | If you are using the spreadsheet, with the date in cell A1 and in date
format (not a text string) this should do what you want
=STRING(YEAR(A1)+1900,0)&IF(MONTH(A1)<10,"0","")&STRING(MONTH(A1),0)
--
Mike - http://pages.prodigy.net/michael_santovec/techhelp.htm
"rod" <pookiethai@NOSPAMiprimus.com.au> wrote in message
news:eSatm3JRIHA.5400@TK2MSFTNGP04.phx.gbl...
Can I process date 12/3/2007 to year/month "200703" etc in another
field?
|
|
|
| Back to top |
|
|
Michael Santovec
Guest
|
| Posted: Sun Dec 23, 2007 9:30 pm Post subject: Re: Date to text: |
|
|
You are welcome and thanks for posting back.
--
Mike - http://pages.prodigy.net/michael_santovec/techhelp.htm
"rod" <pookiethai@NOSPAMiprimus.com.au> wrote in message
news:eampPpPRIHA.3516@TK2MSFTNGP02.phx.gbl...
| Quote: |
Worked like a charm, again, thanks very much.
"Michael Santovec" <michael_santovec@prodigy.net
wrote in message news:euwlTvNRIHA.3516@TK2MSFTNGP02.phx.gbl...
If you are using the spreadsheet, with the date in cell A1 and in
date format (not a text string) this should do what you want
=STRING(YEAR(A1)+1900,0)&IF(MONTH(A1)<10,"0","")&STRING(MONTH(A1),0)
--
Mike - http://pages.prodigy.net/michael_santovec/techhelp.htm
"rod" <pookiethai@NOSPAMiprimus.com.au> wrote in message
news:eSatm3JRIHA.5400@TK2MSFTNGP04.phx.gbl...
Can I process date 12/3/2007 to year/month "200703" etc in another
field?
|
|
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
