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? Quote 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. Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.