shabeer shaik

shabeer shaik

  • NA
  • 40
  • 19.3k

how to enter 3/14 as a barrier draw and not as date

Dec 24 2012 5:07 PM
Hallo There.

Merry Christmas to all.

If i download a file from the web and it has a field called barrier draw into excel i usually use the date format as 3/14. This is actually not a date. sometimes it has 14/15.

How can i format it not to be a date. When i want to select just the first two digits i get 40030. or 40.

i have checked a lot on google and some of your earlier posts but there is nothing regarding this.

thank you

Answers (3)