-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
zero removal
-
A
Need of a simple macro
Hello Everyone, I Need a help . I need a macro which excludes zero and takes the numbers. Can anyone help me. I have searched in this forum.but still iam getting error!! Thanks in Advance Regards, Azadhaz- azadhaz
- Thread
- zero removal
- Replies: 4
- Forum: Excel Questions
-
M
How to retain formatting for hidden data in charts
Hi everyone. I hope someone can help me; this problem is driving me nuts! I have designed a dashboard containing 2 pie charts and a bar chart. Each of these charts has data relating to the same series. I have used the same color-coding for the series in each chart to help visually link them and...- mikerodda
- Thread
- formatting charts zero removal
- Replies: 0
- Forum: Excel Questions
-
D
URGENT Cell's Format Immune to Copy and Paste
Hey all, We are currently using an excel spreadsheet to upload data to a database. We formatted our cells to "text" so that the 0's in front of our numbers don't disappear. However, when you copy and paste something into that cell it changes the formating and the zeros disappear. Is there any...- dset64
- Thread
- copy and paste format formatting a cell urgent zero removal
- Replies: 4
- Forum: Excel Questions
-
M
2010 excel and macro adding zero's to data
Hello all! I am in need of a little help here. I've got my macro to run through my data and spit out the data like I want, EXCEPT; I get an extra "0" added into my data. This is my formulas: Sheet3.Cells(f, 1).Value = "0" & Sheet2.Cells(j, 1).Value & Sheet2.Cells(j, 2).Value & " " &...- msmith83
- Thread
- zero removal
- Replies: 4
- Forum: Excel Questions
