•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Excel custom number format isn't working on some numbers
I am trying to format numbers with hypens in Excel. After a custom format of 00000-0000-00 most worked, but the numbers with leading zeros did not. When I click in the formula bar and enter it changes my number from 00781202001 to 0007-8120-20. How can I apply the same format to the ones with leading zeros and not change the actual number? This is a copy and paste values so it transferred in as General format. If this makes a difference, the Excel options are set to automatically insert a decimal point. Thanks in advance for any advice.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#Excel compatibility
#Excel alternatives
#financial modeling with spreadsheets
#rows.com
#natural language processing for spreadsheets
#AI formula generation techniques
#generative AI for data analysis
#formula generator
#Excel
#custom number format
#leading zeros
#number format
#formatting
#General format
#hypens
#formula bar
#decimal point
#Excel options
#copy and paste