LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Moira
 
Posts: n/a
Default How can I enter 8 digits in excel (eg 19710625) and get it to dis.

I am wondering if I can enter 8 digits in an Excel Cell and have it display
as a date without having to put in a "/" or "-" in between.

Thanks!
Moira
 
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 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
How do I enter a SUM(cell:cell) in pocket excel so it works prope. WillyJ1000 Excel Worksheet Functions 2 February 10th 05 12:14 AM
Office 97 to 2003: Excel: enter data w/fixed 2 decimal. 2000. be. terrier New Users to Excel 1 January 29th 05 10:59 AM
Office 97 to 2003: Excel: enter data w/fixed 2 decimal. 2000. be. terrier New Users to Excel 0 January 29th 05 06:11 AM
How do I enter "1" and have excel know it's equvilant to "$12,000" Jenniefur Excel Discussion (Misc queries) 2 December 8th 04 06:25 PM


All times are GMT +1. The time now is 02:24 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"