• ## Other - General

### Forum Guide

by Published on 2016-11-07 12:48 AM

Getting the Most From Excelguru Forums
We take a lot of pride in providing good help, and really want our users to walk away with an answer to every question.

How the Forum Works

Using the Forum
Before you can post a question, you must register and log into the forum. This is generally a 3-step process:

1. Register
2. Activate

If you haven’t already done so, you need to register for an account by visiting our forum registration page. Fill out the form and click on the white “Complete Registration” button.

Once you’ve submitted your registration, you will receive a confirmation email from (webmaster)@excelguru.ca. Inside that email is an activation link. Please click it to confirm that you’re a real person. ...
• ### Recent Forum Posts

#### Tabs To Share or Data Reference Update

How about 1 workbook using Hide and Protect on the sheets? For your "clear out" piece you could use a simple macro. Just record the steps of...

bobjglover@gmail.com Today, 08:46 PM

#### Append the number 4 and enough Zeros to make all numbers 6 digits long

Hi GreenBoy,

You can simplify this a bit, avoiding a second call to the Text.PadStart function:

Code:
`"4" & Text.PadStart(Number.ToText([CSR`
...

Ken Puls Today, 05:59 PM

#### Append the number 4 and enough Zeros to make all numbers 6 digits long

Ok - so fresh Coffee was what i needed.

The solution is a lot simpler than i was thinking,

Code:
`Text.PadStart(Text.PadStart(Number.ToText([CSR`
...

GreenBoy Today, 05:16 PM

#### A little help with a formula....?

Yes, that is correct....

Ms_Daydream Today, 05:10 PM

#### A little help with a formula....?

If i understand correctly, H05 auto populate's and then your looking to "magically" auto generate your "Cover sheets" in new tabs?...

bobjglover@gmail.com Today, 04:55 PM