-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
date format change
-
M
Date formatting question
I have a cell that references another cell with a date. This is how it is referenced: "&'Source Deed'!B11&" dated "&'Source Deed'!B9&", from "&'Source Deed'!B3&", Grantor(s), to "&'Source Deed'!B6&", Grantee(s), recorded in Volume "&'Source Deed'!B12&" I cannot figure out how to get the...- mjs1982
- Thread
- date format change
- Replies: 5
- Forum: Excel Questions
-
H
Help needed: Wrong date format
Hi there. I working with a dataset extracted from a ERP-system. The ERP-system is delivery a date in the danish format (dd-mm-yyyy), and I are storing the date in a string variable "DateAsString". But when I am doing like this: Worksheets("Sheet1").Cells(1,1).Value=DateAsString VBA translate it...- HansPA
- Thread
- date format change
- Replies: 3
- Forum: Excel Questions
-
K
Cannot Filter Date after changing the format forn date/time stamp
Hi, I'm converting a data dump date field from Date/Time stamp in a query 06.10.2010 02:42:00 using Left/Mid/Right to and concatenating to show 06/10/2010. Though I tried using Cdate to make it a date function and on properties changed it to short date, I can't get it to recognise it as a...- kanoor
- Thread
- date fiilter date format change date time stampp
- Replies: 2
- Forum: Microsoft Access
