PC Review


Reply
Thread Tools Rate Thread

How do I formate cells in excell to show inputed date as 09/13/

 
 
=?Utf-8?B?RGF2ZSBXZW50eg==?=
Guest
Posts: n/a
 
      14th Sep 2006
I have been trying to format colum A to show dates of financial transactions.
I would like to be able to do this in the traditional way of mm/dd/yy. Any
help anyone could offer me would be greatly appreciated. I was ok on
previous versions of Excell, but frankly, I am lost on this version.
--
Dave Wentz
 
Reply With Quote
 
 
 
 
=?Utf-8?B?TWF4?=
Guest
Posts: n/a
 
      14th Sep 2006
Select the column
Click Format > Cells > Number tab
Choose "Custom", then in the "Type:" box, enter: mm/dd/yy
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Dave Wentz" wrote:
> I have been trying to format colum A to show dates of financial transactions.
> I would like to be able to do this in the traditional way of mm/dd/yy. Any
> help anyone could offer me would be greatly appreciated. I was ok on
> previous versions of Excell, but frankly, I am lost on this version.
> --
> Dave Wentz

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
only allow one cell inputed for a range of cells =?Utf-8?B?QnJpYW4=?= Microsoft Excel Misc 8 30th Oct 2007 11:30 PM
how to have result of excell formula remian as if inputed =?Utf-8?B?amltIG1pbGxlcg==?= Microsoft Excel Misc 1 27th May 2007 12:07 AM
what method to use to add 1 day to a date (hotel reservation for one night by clicking on calender) and get it displayed in date formate in a textbox for departure date? Amanda Microsoft VB .NET 2 10th Oct 2006 06:52 AM
HOW TO FORMATE CELLS TO COUNT CELLS WITH A FILL COLOR? =?Utf-8?B?TW9vcmU=?= Microsoft Excel New Users 1 15th Jun 2005 06:41 PM
Relating Cells with Inputed numbers for slope mparker Microsoft Excel Programming 0 13th Mar 2004 12:03 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:02 PM.