How do I put in the date without the year?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I put in the date without the year automatically a part of it? I
want just 12/4 and no year in a box on my data sheet because I want the
column to be short.
 
Barb Byrd said:
How do I put in the date without the year automatically a part of it? I
want just 12/4 and no year in a box on my data sheet because I want the
column to be short.
Click to expand...

How about '12/4. Notice the apostrohe.

/Fredrik
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

dHow do I put in the date without the year? 2
Hello happy new year to all, Text box input for year of purchase 0
Remove date format? 3
Excel Vba to change displayed year automatically. 14
Power Pivot Variance Column 0
how to calculate hrs flown in last one year 0
Adding 10 years to a date 2
year formula 1

Back
Top