View Single Post
 
Old 11-16-2022, 09:22 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

Quote:
Originally Posted by salin View Post
Thanks..............the custom format was just what I was looking for.
Are you sure about this?
Code:
I have product numbers that have zero's in front of them such as (00104)
I suspect you get those product numbers from some other source (ERP system, Web site, ...?). Those number having such format indicates, that those a really text values. I.e. this product number in source is really "00104".
Having a cell formatted so it displays leading zeros doesn't change the value in cell. I.e. when you entered the number 104 into some cell, and formatted it to display 00104, then the value there is really 104. And this is not equal with "00104"! It depends really on your data on sheet, are you getting some problems later because this, or not!

Btw, in case you have in your source product numbers "00104! and "104" (i.e. those are different products there), and you copy those product numbers into Excel cells formatted as general, those product numbers are converted to numbers, and both get numeric value 104!
Reply With Quote