JonnoTheDev Posted May 17, 2010 Share Posted May 17, 2010 Not really a wizz on Excel but need a bit of help manipulating some data. I have a custom formatted cell that contains a datetime i.e 2009-11-04 13:01:50 However, when I attempt to reference in a formula it converts the formatting i.e =""&A2&"" Comes out as 40121.5429398148 Does anyone know how to retain the formatting? Link to comment https://forums.phpfreaks.com/topic/202017-quick-help-with-ms-excel/ Share on other sites More sharing options...
JonnoTheDev Posted May 17, 2010 Author Share Posted May 17, 2010 Ive fixed. Its OK. Link to comment https://forums.phpfreaks.com/topic/202017-quick-help-with-ms-excel/#findComment-1059398 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.