Workbook with VBA now has strange numeric formatting; also, VBA not working anymore

**robpopper** · 08-24-2010, 06:52 PM

I have created a workbook to display golf scores and have written VBA code to fill the cells with a color dependent upon the # of strokes for each hole. All was working just fine until today. It appears that I have inadvertently changed the Excel global settings because now, for example if I enter a '6' in a cell, it will display as '0.06'. How can I undo this mess. Also the VBA code appears to be negated. What's happening?

Any thoughts on the subject will be appreciated. Thanks for looking.

**shg** · 08-24-2010, 07:57 PM

Welcome to the forum, robpopper.

Please take a few minutes to read the forum rules and then amend your thread title accordingly.

We'll get your problem sorted about a nanosecond after that.

**robpopper** · 10-26-2013, 01:02 PM

Sorry to be so very late in responding. The Excel Forum is totally sensational and I certainly wish to abide by the rules. Sorry for any inconvenience and I surely meant no disrespect. I don't see the "edit" option other than in this current post.

**robpopper** · 10-26-2013, 01:06 PM

Just trying to abide by the forum rules and want to change the title of the initial post.

**Fotis1991** · 10-26-2013, 01:09 PM

It's very nice even after 3 years

that you like to do this. So:

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

**robpopper** · 10-26-2013, 01:17 PM

Thanks for the heads up. I wasn't aware of the need to request a moderator to change the title after two days. Thanks again.

**6StringJazzer** · 10-26-2013, 01:32 PM

Rob, to keep things moving along and because you made an effort to change your title to something more descriptive, I have changed it again to something a little better. That title could describe any of thousands of problems posted.

If you are still having this problem, it would be a lot faster to solve if you attach your file.

To post a file:

Under the text box where you type your reply click the Go Advanced button.
In the next screen look above the reply box and click the "paper clip" icon. You will get a pop-up screen.
In the pop-up, click Add then Select to select a file from your local drive
Click the Upload button to upload the file
Click Done to attach it.

It will be displayed as an attachment underneath your post text. Alternatively as the last step you can click the Insert Inline button and a hyperlink to the file will be inserted directly into your post text in the spot where your cursor is set at the moment you click the button.