•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Leading zeros with negative numbers
I have a file with a large amount of leading zeroes. I usually just divide the number by 100 so I can get my decimal point.
My issue is that if some have a negative value, it doesn't do anything. Data provided: 0000-57509 Expected outcome: -575.09 Any suggestions?
[link] [comments]
Want to read more?
Check out the full article on the original site