▲ 1 r/excel
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.
u/Fantastic-Wheel-6917 — 4 hours ago