|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
June 30th, 2008, 01:36 PM
posted to microsoft.public.excel.setup
|
|||
|
|||
Date-error Format
I´m trying to do a sheet make o new date format. The new format should be
yyyymmdd. I have 2008-07-01 (yyyy-mm-dd), but it responds 20080001. The formula I´m using are =TEXT(cell; "ååååmmdd"), do anyone know what´s wrong? BR Mia 
|
|
#2
June 30th, 2008, 02:47 PM
posted to microsoft.public.excel.setup
|
|||
|
|||
|
Date-error Format
Your sample formula is kind of messed up by the special characters in that
formatting string. Are you sure you use yyyy to indicate years in the =text() formula? If you're not using an English version of excel, you'll want to share what you're using. I'd use this (in the USA): =text(a1,"yyyymmdd") or =text(a1;"yyyymmdd") (with the semicolon as the list separator) You may want to type a date in a cell, then use format|Cells|number tab and choose special and then use the equivalent of: yyyymmdd Mia wrote: I´m trying to do a sheet make o new date format. The new format should be yyyymmdd. I have 2008-07-01 (yyyy-mm-dd), but it responds 20080001. The formula I´m using are =TEXT(cell; "ååååmmdd"), do anyone know what´s wrong? BR Mia -- Dave Peterson
|
|
#3
June 30th, 2008, 03:03 PM
posted to microsoft.public.excel.setup
|
|||
|
|||
|
Date-error Format
I'm using at swedish version of Excel and I´m writing the Swedish characters
ååååmmdd, it´s the same for yyyymmdd. Dateformat 20080715 gets =TEXT(H12;"yyyy") answer 2008 =TEXT(H12;"dd") answer 15 =TEXT(H12;"mm") answer 00 // Mia "Dave Peterson" skrev: Your sample formula is kind of messed up by the special characters in that formatting string. Are you sure you use yyyy to indicate years in the =text() formula? If you're not using an English version of excel, you'll want to share what you're using. I'd use this (in the USA): =text(a1,"yyyymmdd") or =text(a1;"yyyymmdd") (with the semicolon as the list separator) You may want to type a date in a cell, then use format|Cells|number tab and choose special and then use the equivalent of: yyyymmdd Mia wrote: I´m trying to do a sheet make o new date format. The new format should be yyyymmdd. I have 2008-07-01 (yyyy-mm-dd), but it responds 20080001. The formula I´m using are =TEXT(cell; "ååååmmdd"), do anyone know what´s wrong? BR Mia -- Dave Peterson
|
|
#4
June 30th, 2008, 03:11 PM
posted to microsoft.public.excel.setup
|
|||
|
|||
|
Date-error Format
You sure that Swedes don't use jjjj for the year.
Your post still has lots of funny characters for me. Mia wrote: I'm using at swedish version of Excel and I´m writing the Swedish characters ååååmmdd, it´s the same for yyyymmdd. Dateformat 20080715 gets =TEXT(H12;"yyyy") answer 2008 =TEXT(H12;"dd") answer 15 =TEXT(H12;"mm") answer 00 // Mia "Dave Peterson" skrev: Your sample formula is kind of messed up by the special characters in that formatting string. Are you sure you use yyyy to indicate years in the =text() formula? If you're not using an English version of excel, you'll want to share what you're using. I'd use this (in the USA): =text(a1,"yyyymmdd") or =text(a1;"yyyymmdd") (with the semicolon as the list separator) You may want to type a date in a cell, then use format|Cells|number tab and choose special and then use the equivalent of: yyyymmdd Mia wrote: I´m trying to do a sheet make o new date format. The new format should be yyyymmdd. I have 2008-07-01 (yyyy-mm-dd), but it responds 20080001. The formula I´m using are =TEXT(cell; "ååååmmdd"), do anyone know what´s wrong? BR Mia -- Dave Peterson -- Dave Peterson
|
|
#5
June 30th, 2008, 03:19 PM
posted to microsoft.public.excel.setup
|
|||
|
|||
|
Date-error Format
I can see that you get a lot of strange characters. I´m usin the right ones but
it get this reslut that I cant solve. "Dave Peterson" skrev: You sure that Swedes don't use jjjj for the year. Your post still has lots of funny characters for me. Mia wrote: I'm using at swedish version of Excel and I´m writing the Swedish characters ååååmmdd, it´s the same for yyyymmdd. Dateformat 20080715 gets =TEXT(H12;"yyyy") answer 2008 =TEXT(H12;"dd") answer 15 =TEXT(H12;"mm") answer 00 // Mia "Dave Peterson" skrev: Your sample formula is kind of messed up by the special characters in that formatting string. Are you sure you use yyyy to indicate years in the =text() formula? If you're not using an English version of excel, you'll want to share what you're using. I'd use this (in the USA): =text(a1,"yyyymmdd") or =text(a1;"yyyymmdd") (with the semicolon as the list separator) You may want to type a date in a cell, then use format|Cells|number tab and choose special and then use the equivalent of: yyyymmdd Mia wrote: I´m trying to do a sheet make o new date format. The new format should be yyyymmdd. I have 2008-07-01 (yyyy-mm-dd), but it responds 20080001. The formula I´m using are =TEXT(cell; "ååååmmdd"), do anyone know what´s wrong? BR Mia -- Dave Peterson -- Dave Peterson
|
|
#6
June 30th, 2008, 05:24 PM
posted to microsoft.public.excel.setup
|
|||
|
|||
|
Date-error Format
I don't speak Swedish, but shouldn't your formula look more like:
=tekst(h12;"jjjj") Mia wrote: I can see that you get a lot of strange characters. I´m usin the right ones but it get this reslut that I cant solve. "Dave Peterson" skrev: You sure that Swedes don't use jjjj for the year. Your post still has lots of funny characters for me. Mia wrote: I'm using at swedish version of Excel and I´m writing the Swedish characters ååååmmdd, it´s the same for yyyymmdd. Dateformat 20080715 gets =TEXT(H12;"yyyy") answer 2008 =TEXT(H12;"dd") answer 15 =TEXT(H12;"mm") answer 00 // Mia "Dave Peterson" skrev: Your sample formula is kind of messed up by the special characters in that formatting string. Are you sure you use yyyy to indicate years in the =text() formula? If you're not using an English version of excel, you'll want to share what you're using. I'd use this (in the USA): =text(a1,"yyyymmdd") or =text(a1;"yyyymmdd") (with the semicolon as the list separator) You may want to type a date in a cell, then use format|Cells|number tab and choose special and then use the equivalent of: yyyymmdd Mia wrote: I´m trying to do a sheet make o new date format. The new format should be yyyymmdd. I have 2008-07-01 (yyyy-mm-dd), but it responds 20080001. The formula I´m using are =TEXT(cell; "ååååmmdd"), do anyone know what´s wrong? BR Mia -- Dave Peterson -- Dave Peterson -- Dave Peterson
|
|
#7
June 30th, 2008, 08:44 PM
posted to microsoft.public.excel.setup
|
|||
|
|||
|
Date-error Format
In the Netherlands we use
jjjj j = jaar Use what this macro tell you instead of y Sub test() MsgBox Application.International(xlYearCode) End Sub -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Dave Peterson" wrote in message ... I don't speak Swedish, but shouldn't your formula look more like: =tekst(h12;"jjjj") Mia wrote: I can see that you get a lot of strange characters. I´m usin the right ones but it get this reslut that I cant solve. "Dave Peterson" skrev: You sure that Swedes don't use jjjj for the year. Your post still has lots of funny characters for me. Mia wrote: I'm using at swedish version of Excel and IÃ,´m writing the Swedish characters ÃfÂ¥ÃfÂ¥ÃfÂ¥ÃfÂ¥mmdd, itÃ,´s the same for yyyymmdd. Dateformat 20080715 gets =TEXT(H12;"yyyy") answer 2008 =TEXT(H12;"dd") answer 15 =TEXT(H12;"mm") answer 00 // Mia "Dave Peterson" skrev: Your sample formula is kind of messed up by the special characters in that formatting string. Are you sure you use yyyy to indicate years in the =text() formula? If you're not using an English version of excel, you'll want to share what you're using. I'd use this (in the USA): =text(a1,"yyyymmdd") or =text(a1;"yyyymmdd") (with the semicolon as the list separator) You may want to type a date in a cell, then use format|Cells|number tab and choose special and then use the equivalent of: yyyymmdd Mia wrote: IÃfâ?sÃ,´m trying to do a sheet make o new date format. The new format should be yyyymmdd. I have 2008-07-01 (yyyy-mm-dd), but it responds 20080001. The formula IÃfâ?sÃ,´m using are =TEXT(cell; "ÃfÆ'Ã,Â¥ÃfÆ'Ã,Â¥ÃfÆ'Ã,Â¥ÃfÆ'Ã,Â¥mmdd"), do anyone know whatÃfâ?sÃ,´s wrong? BR Mia -- Dave Peterson -- Dave Peterson -- Dave Peterson
|
|
#8
July 1st, 2008, 07:10 AM
posted to microsoft.public.excel.setup
|
|||
|
|||
|
Date-error Format
Thank yoy both!
I changed to capital letters and then it work! BR Mia "Ron de Bruin" skrev: In the Netherlands we use jjjj j = jaar Use what this macro tell you instead of y Sub test() MsgBox Application.International(xlYearCode) End Sub -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Dave Peterson" wrote in message ... I don't speak Swedish, but shouldn't your formula look more like: =tekst(h12;"jjjj") Mia wrote: I can see that you get a lot of strange characters. I´m usin the right ones but it get this reslut that I cant solve. "Dave Peterson" skrev: You sure that Swedes don't use jjjj for the year. Your post still has lots of funny characters for me. Mia wrote: I'm using at swedish version of Excel and IÃ,´m writing the Swedish characters ÃfÂ¥ÃfÂ¥ÃfÂ¥ÃfÂ¥mmdd, itÃ,´s the same for yyyymmdd. Dateformat 20080715 gets =TEXT(H12;"yyyy") answer 2008 =TEXT(H12;"dd") answer 15 =TEXT(H12;"mm") answer 00 // Mia "Dave Peterson" skrev: Your sample formula is kind of messed up by the special characters in that formatting string. Are you sure you use yyyy to indicate years in the =text() formula? If you're not using an English version of excel, you'll want to share what you're using. I'd use this (in the USA): =text(a1,"yyyymmdd") or =text(a1;"yyyymmdd") (with the semicolon as the list separator) You may want to type a date in a cell, then use format|Cells|number tab and choose special and then use the equivalent of: yyyymmdd Mia wrote: IÃfâ?sÃ,´m trying to do a sheet make o new date format. The new format should be yyyymmdd. I have 2008-07-01 (yyyy-mm-dd), but it responds 20080001. The formula IÃfâ?sÃ,´m using are =TEXT(cell; "ÃfÆ'Ã,Â¥ÃfÆ'Ã,Â¥ÃfÆ'Ã,Â¥ÃfÆ'Ã,à ‚Â¥mmdd"), do anyone know whatÃfâ?sÃ,´s wrong? BR Mia -- Dave Peterson -- Dave Peterson -- Dave Peterson
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
