Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

Browse Forum Posts by Tags

Showing related tags and posts for the Forums application. See all tags in the site
  • Auto Format option in excel

    Team I am having problem in Excel when it do the auto format. I have a text file which has the following data which are tab separated value Name Date Amount1 Portion XXX 12-5-2008 11.25 10/25 When i load this text file into excel.(By changing the extension from .txt to .xls) It convert 11.25 to 25-Nov...
    Posted to General (Forum) by subhakarthi on Fri, Apr 25 2008
  • Re: Column containing a date

    Mira It is more likely the settings in Windows. Go to the control panel in windows, international settings and set it to your region there. You may need to re-boot and will certainly need to close and restart Excel and the workbook
    Posted to General (Forum) by Nick Hodge on Mon, Mar 31 2008
Page 1 of 1 (2 items)
Copyright Excel User Group and the relevant contributors, 2008. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.