leading 0

Hi there! I have a bunch of code that is working beautifully. I need to add something to the end that will remove leading zeros from negative numbers in column G. The current code shows negative numbers as "0-0.85". Any help is appreciated! Below is my current code: Sub Macro1() Dim...

Hi everyone, First time poster here (please be gentle!). Terribly sorry if this has already been seen before and fixed, again I'm new here, just hoping to learn a little code... Not a wizz with macros and just trying to fix a batch XLSX to CSV macro issue I've got. Anyway, the code works fine...

Hi, Our accounts numbers look like this: 0034-43070-3000-260-561-99 I am creating an excel file where the user, ideally, would want to type in the above account number without hyphens into a cell and then the formatting should automatically insert the hyphens. Problem(s) I ran into are that...

I have a column, which has a comma separated values inside each cell that look like this 0.1, 0.2,0.3, 0.4,0.5, 0.8,1.0 1.5, 1.6,2.0, 10.6,10.9, 15.2,30.75 20, 0.25,280.2, 0.29,300.2, 423,530.76 In a text string. The goal is to remove the leading zero<code style="font-family: Consolas...

here's my question... I have cell A1 with 10230, I want Cell B1 to show 1, C1 to show 0, D1 to show 2, E1 to show 3 and F1 to show 0. for example i tried =value(Right(A1,1)) in cell F1 but got an answer of 3 not the 0 i was expecting. please help....

Hi I am new to this board and have tried every solution to inserting leading zeros. My question is how to insert leading zeros to the following cell entry? 206A 206B 206C 206T I have tried the format function but this does not work due to the fact I have a letter on the end of the cell...

Hi, I work with a lot of data with part numbers. Let's assume that the cells are formatted by Custom - 000000. I have 3 numbers: 001534 095432 473827 Normally without the formatting my numbers would look like: 1534 95432 473827 I copy and pasted the actual 0's and excel seems to think that...