| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Converting a date to a text field w/o converting it to a julian da
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Converting a date to a text field w/o converting it to a julian da
Just use the Text function as is:
=text(a1,"yyyymmdd") Regards, Fred. "LynnMinn" wrote in message ... 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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Converting a date to a text field w/o converting it to a julian da
I'm confused. Are your dates Excel dates? Or are they text? And what would
converting Gregorian dates to Julian dates accomplish? Tyro "LynnMinn" wrote in message ... 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| converting julian dates | Excel Worksheet Functions | |||
| Converting a date field into a month-year only field | Excel Discussion (Misc queries) | |||
| converting julian day and year to a date? | Excel Worksheet Functions | |||
| Excel should have a formula for Converting Julian Dates | Excel Worksheet Functions | |||
| Excel should have a formula for Converting Julian Dates | Excel Worksheet Functions | |||
Hybrid Mode
