Python Forum
Excel from SAP - dealing with formats and VBA
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Excel from SAP - dealing with formats and VBA
#4
Interesting, but not so challenging: your test.xlsx has 2 sheets, Sheet1 and Sheet2

Rows 1 and 2 of column A contain 2 4 digit numbers marked with an apostrophe, which marks them as strings, I believe.

A quick look tells me, this file contains no other data. Maybe you are CIA?

Either, these are coded Nuclear Secrets, masquerading as default formatted numbers or:

What do you want to do with this "data"?
Reply


Messages In This Thread
RE: Excel from SAP - dealing with formats and VBA - by Pedroski55 - Feb-23-2024, 03:34 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  UnicodeEncodeError - Dealing with Japanese Characters fioranosnake 2 2,619 Jul-07-2022, 08:43 PM
Last Post: fioranosnake
  Dealing with duplicated data in a CSV file bts001 10 11,952 Sep-06-2021, 12:11 AM
Last Post: SamHobbs
  [split] NameError: name 'formats' is not defined shobhu123 1 4,145 May-24-2020, 06:29 PM
Last Post: Skaperen
  Need help working with two excel file with different formats mikey3580 1 1,676 Apr-22-2020, 07:11 AM
Last Post: DPaul
  Dealing with a .json nightmare... ideas? t4keheart 10 4,517 Jan-28-2020, 10:12 PM
Last Post: t4keheart
  How to convert different timestamp formats? python_newbie09 12 7,126 Aug-05-2019, 06:37 PM
Last Post: python_newbie09
  Dealing with Exponential data parthi1705 11 10,057 May-30-2019, 10:16 AM
Last Post: buran
  Dealing with multiple context managers heras 5 4,863 Nov-16-2018, 09:01 AM
Last Post: DeaD_EyE
  How to generate calendar with 2 formats in python luizcrf 1 2,740 Nov-01-2018, 06:46 AM
Last Post: Larz60+
  dealing with big data of timestamp LMQ 0 2,220 Jul-27-2018, 01:23 PM
Last Post: LMQ

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020