Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default How to format date cells, Excel template Project scorecard matrix

Using Excel 2003 template (Project scorecard matrix) I format the cell as
date 03/14/01. Each time I enter a date it returns a date valve and if I do
not format the cell and enter a date 10/4/06 it automatically formats as
*3/14/01.
How can the cell be saved in the format selected?
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel date format trouble michaelberrier Excel Discussion (Misc queries) 2 April 21st 06 06:21 AM
English date format and compatibilty with others Excel Language [email protected] Excel Discussion (Misc queries) 1 April 14th 06 11:22 AM
Excel: I enter date and format for date, but shows as number spohar Excel Discussion (Misc queries) 2 March 10th 06 09:40 PM
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER MEGTOM New Users to Excel 5 October 27th 05 04:06 AM
Australian date format in Excel 2000 Brian Jones Excel Discussion (Misc queries) 2 March 30th 05 07:13 AM


All times are GMT +1. The time now is 02:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"