Converting a date to a text field w/o converting it to a julian da

's Computer Specifications

In order to import data from an Excel spreadsheet into the software I operate
at work all cells need to be formated as text. I recieve numerous
spreadsheets with the date formated as a date XX/XX/XXXX and I need to
convert it to text XXXXXXXX. How can this be done without converting the
number to a julian date?

's Computer Specifications

Just use the Text function as is:

=text(a1,"yyyymmdd")

Regards,
Fred.

"LynnMinn" <(E-Mail Removed)> wrote in message
news:A91E6781-D028-407C-9E47-(E-Mail Removed)...
> In order to import data from an Excel spreadsheet into the software I
> operate
> at work all cells need to be formated as text. I recieve numerous
> spreadsheets with the date formated as a date XX/XX/XXXX and I need to
> convert it to text XXXXXXXX. How can this be done without converting the
> number to a julian date?

's Computer Specifications

I'm confused. Are your dates Excel dates? Or are they text? And what would
converting Gregorian dates to Julian dates accomplish?

Tyro

"LynnMinn" <(E-Mail Removed)> wrote in message
news:A91E6781-D028-407C-9E47-(E-Mail Removed)...
> In order to import data from an Excel spreadsheet into the software I
> operate
> at work all cells need to be formated as text. I recieve numerous
> spreadsheets with the date formated as a date XX/XX/XXXX and I need to
> convert it to text XXXXXXXX. How can this be done without converting the
> number to a julian date?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
converting a number to a Julian Date	LisaK	Microsoft Access	2	22nd Mar 2010 09:04 PM
Converting Date to Julian	Sam	Microsoft Access	4	6th Jan 2010 03:19 AM
converting julian day and year to a date?	=?Utf-8?B?Q2hhZCBOb3JkYmVyZw==?=	Microsoft Excel Worksheet Functions	1	27th Feb 2006 10:23 PM
WS formula for Julian date not converting well to VBA??	Ed	Microsoft Excel Programming	6	10th Feb 2005 05:33 PM
Re: Converting from Julian Date	Wayne Morgan	Microsoft Access VBA Modules	0	27th Aug 2003 12:17 AM