Results 1 to 4 of 4

Thread: Microsoft Office Spreadsheet 10 cells format ?

  1. Mar 8th, 2007, 10:28 AM #1
    azbuz
    azbuz is offline

    Thread Starter
    Member
    Join Date
    Nov 2006
    Posts
    41

    Microsoft Office Spreadsheet 10 cells format ?

    I use Microsoft Office Spreadsheet 10. I connect spreadsheet to a web page.
    İt brings data correctly but some cells view wrong format.
    some cells (like " 1-1 " ) view date format (like " 1-January"). How can fix it ?
    Reply With Quote Reply With Quote
  2. Mar 8th, 2007, 11:08 AM #2
    Asgorath
    Asgorath is offline
    Frenzied Member Asgorath's Avatar
    Join Date
    Sep 2004
    Location
    Saturn
    Posts
    2,036

    Re: Microsoft Office Spreadsheet 10 cells format ?

    When reading the cells you need to use the appropriate number format.
    "The dark side clouds everything. Impossible to see the future is."
    Reply With Quote Reply With Quote
  3. Mar 8th, 2007, 12:44 PM #3
    RobDog888
    RobDog888 is offline
    Ex-Super Mod RobDog888's Avatar
    Join Date
    Apr 2001
    Location
    LA, Calif. Raiders #1 AKA:Gangsta Yoda™
    Posts
    60,709

    Re: Microsoft Office Spreadsheet 10 cells format ?

    Format your column/cells as the desired format first otherwise Excel has to guess at the expected data type and may get it wrong.
    VB/Office Guru™ (AKA: Gangsta Yoda™ ®)
    I dont answer coding questions via PM. Please post a thread in the appropriate forum.

    Microsoft MVP 2006-2011
    Office Development FAQ (C#, VB.NET, VB 6, VBA)
    Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
    If a post has helped you then Please Rate it!
    • Reps & Rating Posts • VS.NET on Vista • Multiple .NET Framework Versions • Office Primary Interop Assemblies • VB/Office Guru™ Word SpellChecker™.NET • VB/Office Guru™ Word SpellChecker™ VB6 • VB.NET Attributes Ex. • Outlook Global Address List • API Viewer utility • .NET API Viewer Utility •
    System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6
    Reply With Quote Reply With Quote
  4. Mar 9th, 2007, 01:51 AM #4
    azbuz
    azbuz is offline

    Thread Starter
    Member
    Join Date
    Nov 2006
    Posts
    41

    Re: Microsoft Office Spreadsheet 10 cells format ?

    Spreadsheet has no contain string format feature. to use general format not work. otherwise if I use excel , it contains "dont date identify feature" and it works but spreadsheet activex has no contains this feature. Can I do promrammatickly?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width