LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Empty cells showing that they are default formated to "Date"

I created a spead sheet with one column set as a date the first to the end of
the month. The other columns have various in text and accounting info.
If I click on a empty cell it show in the format section on the bar the the
cell is set up to have a date entry. This is all over the page. Can any one
tell me why this is happening?
--
Fred
 
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
Get "AVERAGE" function to ignore empty cells Ed O'Brien Excel Discussion (Misc queries) 6 August 5th 09 10:07 PM
Cannot find "Plot empty cells as" option in 2007 Jack Tripper Charts and Charting in Excel 6 November 26th 08 12:38 PM
syntax for "IF" commend to check for multiple empty cells bf comma Chris Excel Worksheet Functions 4 September 3rd 07 12:02 PM
"treat empty cells as" is greyed out in charts Fletch260473 Charts and Charting in Excel 1 July 8th 07 07:44 PM
Showing "Created by User, Date, Time" in Footer Mark Plaideau Excel Discussion (Misc queries) 0 April 9th 06 11:29 PM


All times are GMT +1. The time now is 10:01 PM.

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"