LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 25
Default Having a problem formatting short time

I am having a problem formatting time in my spreadsheet. If I type in a
number (ex. 1300) and then try to format the cell this is what happens ....
the cell changes to 00:00 and the formula bar shows 7/23/1903 12:00 AM. Can
anyone help me? I give up!
--

 
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
Short Date Formatting Majikwoman Excel Discussion (Misc queries) 8 June 21st 08 02:00 AM
Time Formatting Problem mpenkala Excel Discussion (Misc queries) 1 June 2nd 08 09:30 PM
Date & time short cut Conditional Formatting Excel Worksheet Functions 1 November 21st 05 05:05 PM
Problem with formatting time Tcs Excel Discussion (Misc queries) 2 November 3rd 05 06:48 PM
Despite formatting a column in Excel 2002 worksheet as Short Date. Pete Whalley Excel Discussion (Misc queries) 2 February 7th 05 06:17 PM


All times are GMT +1. The time now is 06:13 AM.

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"