Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 23rd 06, 04:27 PM posted to microsoft.public.excel.newusers
Ralphael1
 
Posts: n/a
Default Dates in cells

When I start a spreadsheet my first step is to format the columns and
the date format is selected.
Occasionally when entering dates they do not follow the format for that
column or other dates in that column.
Am I doing something wrong?
Anyone else have this problem.

Ralphael, the OLD one


  #2   Report Post  
Old January 27th 06, 03:35 AM posted to microsoft.public.excel.newusers
farquiza
 
Posts: n/a
Default Dates in cells

Hi Ralphael1,

You may want to create an excel template for your date format.
Just type this on the cell "=NOW( )" format the cell you prefer.

"Ralphael1" wrote:

When I start a spreadsheet my first step is to format the columns and
the date format is selected.
Occasionally when entering dates they do not follow the format for that
column or other dates in that column.
Am I doing something wrong?
Anyone else have this problem.

Ralphael, the OLD one




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
Auto Formatting Cells and Dates Sloth Excel Discussion (Misc queries) 1 August 17th 05 12:29 AM
how would I count dates (not # of days) in cells that fall betwee. sailingscotts Excel Worksheet Functions 3 August 16th 05 04:29 AM
automatically highlight cells with expired dates?! cwest123456 Excel Discussion (Misc queries) 2 August 1st 05 06:20 PM
requires that merged cells must be identically sized? Catt Excel Discussion (Misc queries) 11 July 3rd 05 12:36 PM
highlighting cells which have dates later than... Rory Carroll Excel Discussion (Misc queries) 6 February 3rd 05 11:39 PM


All times are GMT +1. The time now is 01:47 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017