M MarcoT May 5, 2009 #1 Need to save as this format and style for a connected system. will even accept work arounds if they go through.
Need to save as this format and style for a connected system. will even accept work arounds if they go through.
P Pete_UK May 5, 2009 #2 Use this in a helper column: =TEXT(A1,"dd mmm yyyy") then copy down. Fix the values and then copy the values over to the original column and then delete the helper column. Hope this helps. Pete
Use this in a helper column: =TEXT(A1,"dd mmm yyyy") then copy down. Fix the values and then copy the values over to the original column and then delete the helper column. Hope this helps. Pete
F Francis May 5, 2009 #3 Format >> Cells >> Custom type dd mmm yyyy click OK or use this formula in B2 =TEXT(A2,"dd mmm yyyy") -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked Thank You cheers, francis Am not a greek but an ordinary user trying to assist another
Format >> Cells >> Custom type dd mmm yyyy click OK or use this formula in B2 =TEXT(A2,"dd mmm yyyy") -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked Thank You cheers, francis Am not a greek but an ordinary user trying to assist another
