Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Hour Format in Excel
Name: glozano Date: July 19, 2005 at 13:46:29 Pacific OS: Windows XP CPU/Ram: Centrino / 512
Comment:
How can i format a cell with this format "01:58:26p.m. to this "13:58:26" Thanks
Name: Kurt S Date: July 19, 2005 at 13:52:05 Pacific
Reply:
highlight the cell, right click and choose format. Select the time option and it will give you several options has to how you want to view the time. Select the one you want.
Summary: http://www.computing.net/answers/of... I have got same issue in the link above, how can I change date format in Excel 2003 to dd/mm/yy (28/03/09),,,,there is no such an option in Format --> Cell --> "...
Summary: Hi, The formulas for conditional formatting that DerbyDad03 gave you do work in Excel 2007. Maybe you didn't enter them correctly. Excel 2007 has a load more options for conditional formatting than 20...
Summary: Okay. Now I understand what you are trying to do. The only way I know of is to use VBA code. You would have to convert the raw number into a format that Excel would recognize as a date 20051001 into ...
0 
