February 18, 2026•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?

Check out the full article on the original site

#Excel alternatives for data analysis

#rows.com

#financial modeling with spreadsheets

#big data management in spreadsheets

#generative AI for data analysis

#conversational data analysis

#Excel compatibility

#large dataset processing

#real-time data collaboration

#intelligent data visualization

#leading zeros

#negative numbers

#decimal point

#data

#file

#value

#suggestions

#divide

#outcome

#context