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: 2
Default date format won't show

I have a problem - I have inserted a date such as 12/10/2007 and it usually
will automatically knows it's a date and formats it as date BUT now in my
worksheet when i put in a date it won't allow me to format to date (even
though it displays in the formmual bar) and won't wllow me to change the
alignment to vertical? Anybudy know why? It keeps displaying a seruial number
and won't budge !!!
 
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 shows on formula bar, 5 digit numbers show in row CaroleO Excel Discussion (Misc queries) 1 March 5th 07 08:11 PM
How to format cells to show dates as the week-ending date of that dereksmom Excel Worksheet Functions 1 July 12th 06 04:40 PM
Excel 2000 date format cannot be set to Australian date format Brian Jones Excel Discussion (Misc queries) 1 March 30th 05 06:03 AM
How do I format the date to show mm/dd NOT m/dd? smags Excel Worksheet Functions 1 January 25th 05 07:39 PM
How do I format column containing date and time to only show the . ColoradoKid Excel Discussion (Misc queries) 5 December 18th 04 05:25 PM


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