LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Weird format to formula transition excel 2003

When entering a date into a cell even after changing the format to Date
format, excel is viewing my entry as a formula.

Here's my process:
I choose format cells, date, okay.
enter 10/19/06
display shows 1/0/1900

cell display shows =10/19/6

I've chosen multiple date formats with the same result.

Ideas?

 
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 sum figures without formula PULIDOC Excel Worksheet Functions 2 April 28th 06 06:27 PM
Excel 2003 Insert Picture changes JPG to PNG format WildBill Excel Discussion (Misc queries) 1 December 1st 05 12:41 AM
Excel 2003 Inserted pictures formatted in PNG format. WildBill Excel Discussion (Misc queries) 0 November 18th 05 09:03 PM
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER MEGTOM New Users to Excel 5 October 27th 05 03:06 AM
Excel 2003 row height format Moises Colin Excel Discussion (Misc queries) 0 October 25th 05 06:35 PM


All times are GMT +1. The time now is 05:12 AM.

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

About Us

"It's about Microsoft Excel"