LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LeoTernes
 
Posts: n/a
Default How do I format an Excel date earlier than 1900?

I downloaded the XDATE function. Now how do I format all the cells in a
column so I can just type in the dates earlier than 1900 in the following
format: dd-mmm-yyyy?
 
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
Date format not correct when you convert a CSV text file in Excel Scarab Excel Discussion (Misc queries) 2 November 16th 05 12:22 PM
How change Excel default date format to something useful mjk Excel Discussion (Misc queries) 1 September 26th 05 08:15 PM
How do I maintain my date format, when I copy a sheet, in excel? DHT Excel Discussion (Misc queries) 2 June 29th 05 03:31 AM
Keeping date format of a field inserted from an excel database Tim Cossins Excel Worksheet Functions 1 May 21st 05 12:49 AM
date format in Excel mac@bath Excel Discussion (Misc queries) 3 May 15th 05 09:27 AM


All times are GMT +1. The time now is 06:21 PM.

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"