| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Text concantenated with a link to another spreadsheet field
I have some notations in a cell and then I have added a link to another
spreadsheets' field that is a date. When I look at the information the date is given in Julian format. How do I get it to be in mm/dd/yyyy format? Excel 2000. Thx, CLM |
|
#2
|
|||
|
|||
|
="this is the due date: " & text(sheet2!a1,"mm/dd/yyyy")
CLM wrote: I have some notations in a cell and then I have added a link to another spreadsheets' field that is a date. When I look at the information the date is given in Julian format. How do I get it to be in mm/dd/yyyy format? Excel 2000. Thx, CLM -- Dave Peterson |
|
#3
|
|||
|
|||
|
Or if your formula was just:
=sheet1!a1 just format the cell the way you want (format|cells|number tab) CLM wrote: I have some notations in a cell and then I have added a link to another spreadsheets' field that is a date. When I look at the information the date is given in Julian format. How do I get it to be in mm/dd/yyyy format? Excel 2000. Thx, CLM -- Dave Peterson |
|
#4
|
|||
|
|||
|
Dave,
Thank you so much. I know in Access it's Format(sheet2!a1,"mm/dd/yyyy") but that didn't exist in Excel and help wasn't much help. CLM "Dave Peterson" wrote: ="this is the due date: " & text(sheet2!a1,"mm/dd/yyyy") CLM wrote: I have some notations in a cell and then I have added a link to another spreadsheets' field that is a date. When I look at the information the date is given in Julian format. How do I get it to be in mm/dd/yyyy format? Excel 2000. Thx, CLM -- Dave Peterson |
|
#5
|
|||
|
|||
|
When I put in the syntax as you suggested below:
=+'E:\0412\[hproj.xls]Port'!$AZ$6 & " - " & TEXT('E:\0412\[hproj.xls]Port'!$BE$6,"mm/dd/yyyy") I get the result of #VALUE! The text() goes infront of the connection to the folder path correct? CLM "Dave Peterson" wrote: ="this is the due date: " & text(sheet2!a1,"mm/dd/yyyy") CLM wrote: I have some notations in a cell and then I have added a link to another spreadsheets' field that is a date. When I look at the information the date is given in Julian format. How do I get it to be in mm/dd/yyyy format? Excel 2000. Thx, CLM -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Link Text to an Associated Number | Excel Worksheet Functions | |||
| Sort or Filter option? | Excel Worksheet Functions | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
| Link the value to text in a cell, then use that text cell in a for | Excel Worksheet Functions | |||
| I am trying to link based on a text value instead of cell position | Links and Linking in Excel | |||
Linear Mode
