#1   Report Post  
Old June 30th 08, 01:36 PM posted to microsoft.public.excel.setup
Mia Mia is offline
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2006
Posts: 101
Default 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   Report Post  
Old June 30th 08, 02:47 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 35,218
Default 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   Report Post  
Old June 30th 08, 03:03 PM posted to microsoft.public.excel.setup
Mia Mia is offline
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2006
Posts: 101
Default 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   Report Post  
Old June 30th 08, 03:11 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 35,218
Default 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   Report Post  
Old June 30th 08, 03:19 PM posted to microsoft.public.excel.setup
Mia Mia is offline
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2006
Posts: 101
Default 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   Report Post  
Old June 30th 08, 05:24 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 35,218
Default 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   Report Post  
Old June 30th 08, 08:44 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 11,123
Default 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:

If?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 If?s,´m using are =TEXT(cell; "f',¥f',¥f',¥f',¥mmdd"), do anyone know whatf?s,´s
wrong?

BR
Mia

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson


  #8   Report Post  
Old July 1st 08, 07:10 AM posted to microsoft.public.excel.setup
Mia Mia is offline
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2006
Posts: 101
Default 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





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Error in date format of first Pivot table chart OveBonde Charts and Charting in Excel 0 April 7th 08 12:23 PM
Date format error in Excel Richy Rich Excel Worksheet Functions 6 February 2nd 07 10:36 PM
How do I fix a date format error in Excel? Dale_C141 Excel Discussion (Misc queries) 2 May 27th 06 06:09 AM
Date Format Correct, But Formula Error john_mc Excel Discussion (Misc queries) 1 April 10th 06 04:25 AM
Date Format - April error Zane Lassiter Excel Discussion (Misc queries) 1 February 1st 06 02:45 PM


All times are GMT +1. The time now is 12:54 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017