Hi Friends,
I have a number, 929453272. How can I convert this number to a valid date format (dd/mm/yyyy).
Regs.
Jay.
Printable View
Hi Friends,
I have a number, 929453272. How can I convert this number to a valid date format (dd/mm/yyyy).
Regs.
Jay.
well you can use a Format$(312876287, "dd/mm/yyyy") but it only will really work if the number means something (from the old dos era, we had 'daynumbers', number of days elapsed since a certain date. With a function we could transfer that to a date)
Crazy D @ Work :-)