Some financial values being formatted as Date
*Created originally on Bitbucket by [robertkarl (Robert Karl)](https://bitbucket.org/%7B7ea2417d-9b2c-46a7-b069-9bf323e971e4%7D/)* **BUG DESCRIPTION** If you have a numeric cell holding cryptocurrency values, like an ethereum quantity, you might want to format it like so: ``` 3.0 ETH ``` while the value of the cell may be just 3. Openpyxl looks at the format string ETH and decides it is a date format because it contains H. \`cell.value\` will be a date. In particular it will be Jan 3, 1900 for this cell. **MY FIX** I fixed this in my local fork of your project with the following in styles/numbers.py, hopefully without destroying too much else: ``` def is_date_format(fmt): if fmt is None: return False fmt = fmt.split(";")[0] # only look at the first format fmt = STRIP_RE.sub("", fmt) import string date_like = 'dmhysDMHYS' others = set(string.ascii_letters) for i in date_like: others.discard(i) others = "".join(others) result = re.search("[dmhysDMHYS]", fmt) oppo = re.search("[{}]".format(others), fmt) result = (result is not None) and (oppo is None) return result ``` ‌ I’d be happy to open a pull request or add more details when I have a bit more time. I think this occurs in 3.0.3 at least. Single-cell workbook attached which should repro the problem. *Attachments:* [28_eth.xlsx](/uploads/76272c0d5546ca68536f9966a490df73/28_eth.xlsx)
issue