changing date format
 

I have spreadsheets with dates I need to convert in order to send info. to
customer electronically.

Current spreadsheet shows 09/20/08 or September 20, 2008
Need it to show 080920 with no slashes

Can anybody help me?

--
Julie

changing date format
 

Right-click on cell, Format Cells Custom Type = yymmdd

Regards,
Ryan--

--
RyGuy


"Julie" wrote:

I have spreadsheets with dates I need to convert in order to send info. to
customer electronically.

Current spreadsheet shows 09/20/08 or September 20, 2008
Need it to show 080920 with no slashes

Can anybody help me?

--
Julie

changing date format
 

Wow - easy - but I hadn't figured it out. Thank-you so much - you saved me
a ton of time!!!
--
Julie


"ryguy7272" wrote:

Right-click on cell, Format Cells Custom Type = yymmdd

Regards,
Ryan--

--
RyGuy


"Julie" wrote:

I have spreadsheets with dates I need to convert in order to send info. to
customer electronically.

Current spreadsheet shows 09/20/08 or September 20, 2008
Need it to show 080920 with no slashes

Can anybody help me?

--
Julie

changing date format
 

That won't "convert" the dates, just display them differently.

The underlying value will still be 09/20/08 or September 20, 2008

Do you need them actually "converted" to a text value of 080920 ?

="0"&(YEAR(A1)-2000)*10000+MONTH(A1)*100+DAY(A1)


Gord Dibben MS Excel MVP


On Mon, 21 Jan 2008 11:51:02 -0800, Julie
wrote:

Wow - easy - but I hadn't figured it out. Thank-you so much - you saved me
a ton of time!!!

changing date format
 

I have a similar question...how can you set a new Custom date in the cell
format application?
--
Thanks, Kathy


"Gord Dibben" wrote:

That won't "convert" the dates, just display them differently.

The underlying value will still be 09/20/08 or September 20, 2008

Do you need them actually "converted" to a text value of 080920 ?

="0"&(YEAR(A1)-2000)*10000+MONTH(A1)*100+DAY(A1)


Gord Dibben MS Excel MVP


On Mon, 21 Jan 2008 11:51:02 -0800, Julie
wrote:

Wow - easy - but I hadn't figured it out. Thank-you so much - you saved me
a ton of time!!!

changing date format
 

Select the date you want to format. The Ctrl+1. Select Numbers tab. Select
custom. In the "Type:" box enter the format you want - e.g. m/d/yyyy or
select one of the existing formats. See Excel help for the possible formats
you can use.

Tyro


"Kathy" wrote in message
...
I have a similar question...how can you set a new Custom date in the cell
format application?
--
Thanks, Kathy


"Gord Dibben" wrote:

That won't "convert" the dates, just display them differently.

The underlying value will still be 09/20/08 or September 20, 2008

Do you need them actually "converted" to a text value of 080920 ?

="0"&(YEAR(A1)-2000)*10000+MONTH(A1)*100+DAY(A1)


Gord Dibben MS Excel MVP


On Mon, 21 Jan 2008 11:51:02 -0800, Julie

wrote:

Wow - easy - but I hadn't figured it out. Thank-you so much - you
saved me
a ton of time!!!

changing date format
 

FormatCellNumberCustom.

Enter your Custom Format.

Save the Workbook.

The custom is saved with that workbook only and is not a global custom.

To make it a global custom format you would have to create a workbook template
upon which all new workbooks are based.

Open a new workbook. Customize cells as you wish with your number format.

FileSave As Type: scroll down to Excel Template(*.XLT) and select. Name your
workbook "BOOK"(no quotes). Excel will add the .XLT to save as BOOK.XLT.

Store this workbook in the XLSTART folder usually located at........

C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART

This will be the default workbook for FileNew or the Toolbar button FileNew or
CTRL + n

WARNING................Do not use FileNew...Blank Workbook or you will get the
Excel default workbook.

NOTE: Existing workbooks are not affected by these settings.

You can also open a new workbook and delete all but one sheet. Customize as
you wish then save this as SHEET.XLT in XLSTART folder also. It now becomes
the default InsertSheet.

More can be found on this in Help under "templates"(no quotes).

Alternative................create a small macro saved in your Personal.xls and
assign it to a button.


Gord


On Mon, 21 Jan 2008 13:02:00 -0800, Kathy
wrote:

I have a similar question...how can you set a new Custom date in the cell
format application?

changing date format
 

That won't "convert" the dates, just display them differently.

The underlying value will still be 09/20/08 or September 20, 2008

Do you need them actually "converted" to a text value of 080920 ?

="0"&(YEAR(A1)-2000)*10000+MONTH(A1)*100+DAY(A1)

Or even like this..

=TEXT(A1,"yymmdd")

Rick

changing date format
 

Try this:

TEXT(A1,"yymmdd")


"Julie" wrote:

I have spreadsheets with dates I need to convert in order to send info. to
customer electronically.

Current spreadsheet shows 09/20/08 or September 20, 2008
Need it to show 080920 with no slashes

Can anybody help me?

--
Julie

changing date format
 

Now why didn't I think of that? <vbg

Rick


"Teethless mama" wrote in message
...
Try this:

TEXT(A1,"yymmdd")


"Julie" wrote:

I have spreadsheets with dates I need to convert in order to send info.
to
customer electronically.

Current spreadsheet shows 09/20/08 or September 20, 2008
Need it to show 080920 with no slashes

Can anybody help me?

--
Julie

changing date format
 

I have just the opposite issue - I need:
08242007 converted to 08/24/07
Please help - I'm getting ############# error not due to column size..
Thanks



"Julie" wrote:

I have spreadsheets with dates I need to convert in order to send info. to
customer electronically.

Current spreadsheet shows 09/20/08 or September 20, 2008
Need it to show 080920 with no slashes

Can anybody help me?

--
Julie

changing date format
 

First, don't hijack threads. If you have a new problem post it in a new
thread. You'll get a much better response.

Second, if you need it converted to a date, then just convert it. Try:

=date(right(a1,4),left(a1,2),mid(a1,3,2))

Regards,
Fred.

"util" wrote in message
...
I have just the opposite issue - I need:
08242007 converted to 08/24/07
Please help - I'm getting ############# error not due to column size..
Thanks



"Julie" wrote:

I have spreadsheets with dates I need to convert in order to send info.
to
customer electronically.

Current spreadsheet shows 09/20/08 or September 20, 2008
Need it to show 080920 with no slashes

Can anybody help me?

--
Julie

changing date format
 

DataText to ColumnsNextNextColumn Data FormatDateMDY and Finish.


Gord Dibben MS Excel MVP

On Fri, 2 May 2008 07:03:03 -0700, util wrote:

I have just the opposite issue - I need:
08242007 converted to 08/24/07
Please help - I'm getting ############# error not due to column size..
Thanks



"Julie" wrote:

I have spreadsheets with dates I need to convert in order to send info. to
customer electronically.

Current spreadsheet shows 09/20/08 or September 20, 2008
Need it to show 080920 with no slashes

Can anybody help me?

--
Julie