Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

Decimal to date in excel

Comment:

Hi, i am needing help with a strange issue. i have an excel spreadsheet that randomly changed my daten to decimal format. i have 3 pages on the spreadsheet and only one changed. i have done nothing different i dont think. any suggestions would help. thanks, jason Thanks, Jason

Name: Mike (by mmcconaghy)
Date: March 20, 2009 at 10:00:31 Pacific

Reply:

First thing I'd check is Formatting issues. MIKE

0

Reply:

i have already made sure that the cells are formatted exactly the same as one of the pages that are working. all looks good at that end. Thanks, Jason

0

Name: Mike (by mmcconaghy)
Date: March 20, 2009 at 11:41:50 Pacific

Reply:

Without knowing what your doing...... Have any macros that might be running wild? Do the cell change randomly or is there a pattern? How are the cells formatted? MIKE

0

excel date format problem

Error Message

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: Hi, Please help me in comparing dates in Excel. Let the cells have dates as given below... A2 = 10-Jan-2009 B2 = 20-Feb-2009 C2 = 30-Mar-2009. I need a formula that checks if C2 is equal to an...

Summary: Actually, for your string you would need to use: =MID(A1,5,2)&"/"&RIGHT(A1,2)&"/"&(LEFT(A1,4)) With your string in A1, click on the cell where you want to see 03/14/2004 and paste in the formula. It c...

Summary: Is there any way to disregard weekends and / or holidays when subtracting dates in Excel? ...