Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel formatting issue on file open

Status
Not open for further replies.

Smoothcat74

Technical User
Aug 29, 2008
40
Ok, here's my issue. I am opening a Visual C# file using Microsoft Excel 2007. When I'm using my work PC, everything formats great. When I'm using my laptop, not so much. Specifically, when I open the file on the laptop Excel doesn't auto-format the "DATE" field and instead return a numeric value like "20080828". Both computers are running Excel 2007. Both have Visual C# installed (although I don't think that would be a factor.) Yet for some reason, I don't get the same results opening these files on the respective machines.

Can anyone out there give me an inkling as to what the heck is going on? It's driving me nutty.
 





Hi,

Hmmmmm? Returns 20080828?

What happens when you format that cell as GENERAL?

"I am opening a Visual C# file..."

HOW? Using OPEN or using IMPORT?



Skip,

[glasses]Just traded in my old subtlety...
for a NUANCE![tongue]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top