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

L

LynnMinn

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?
 
T

Tyro

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

Tyro
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do i convert dates to text but keep the date format 1
converting number to dollar 10
converting julian day and year to a date? 1
how to convert julian date to regular calendar date 5
How do I get the date to display a Julian date? (yyddd) 2
Convert Date to Julian Date 2
converting a number to a Julian Date 2
test to Julian date 10

Top