G Guest Nov 19, 2004 #1 i have a date appearing in excel as 1000203 and I need it converted to 03/02/2000, any help would be good. Thanks.
i have a date appearing in excel as 1000203 and I need it converted to 03/02/2000, any help would be good. Thanks.
J JulieD Nov 19, 2004 #2 Hi Neville i've replied under a previous post from you entitiled "more date conversions" ... will my solutions work for your situation? Cheers julieD
Hi Neville i've replied under a previous post from you entitiled "more date conversions" ... will my solutions work for your situation? Cheers julieD
R Ron Rosenfeld Nov 19, 2004 #3 i have a date appearing in excel as 1000203 and I need it converted to 03/02/2000, any help would be good. Thanks. Click to expand... Hard to tell you what to do without knowing what your numbers represent. As written, they are ambiguous. For example, the output, depending on your format, could be 03 Feb 2000 or 02 Mar 2000 --ron
i have a date appearing in excel as 1000203 and I need it converted to 03/02/2000, any help would be good. Thanks. Click to expand... Hard to tell you what to do without knowing what your numbers represent. As written, they are ambiguous. For example, the output, depending on your format, could be 03 Feb 2000 or 02 Mar 2000 --ron
