Thread: date format
View Single Post
 
Old 12-28-2011, 04:02 AM
gsrikanth gsrikanth is offline Windows XP Office XP
Competent Performer
  
Join Date: Dec 2011
Posts: 133
gsrikanth is on a distinguished road
Default date format
in the excel cell iam trying type 5-43 it is comming 15827. how i get 5-43 instead of 15837?

if i convert 15827 in custom m-yy it is going to 5-43. my question is '-' not replacing by . ? i want 5-43 to 5.43.
Reply With Quote