# Need Help Please with Excel Formula

#### Lindee

##### New Member
just a thought but aside from what you are looking for try typing this in any cell

=RANDBETWEEN(100,999)

this will generate a random 3 digit number just press the F9 Key to get a new number
Used your formula and I'm testing now. It may turn out to be helpful. Thank you again
I

### Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

#### Dryver14

##### Well-known Member
Your welcome.....I'm thinking 20 - 30% of any winning lol

#### Lindee

##### New Member
Your welcome.....I'm thinking 20 - 30% of any winning lol
Good enough for me Thank you again,,,,
I found this formula on another site:
"In A1, enter the number 10.
In A2, enter the formula =A1+1. Fill down to A90.
In B1: =TEXT(A1,"00")&RIGHT(TEXT(A1,"00"),1)&LEFT(TEXT(A1 ,"00"),1)
Fill down.

--
Kind regards,

Niek Otten"

Wanted to give the guy his credit. Maybe you can use it.
Good Luck
Linda

#### Lindee

##### New Member
Hey Marcelo Branco,,,,I found a resolution to the issue of not being able to post the formula in the cells....I pasted the formula in the cell, then went to the formula bar, took out the = sign from the formula, then put the = sign in again and it WORKED it excepted the formula....I figured it out on my own ,,,very simple. Incase you have someone with the same issue. Still have the "Value Error" but that's ok, I found another formula... Thank you again for all your hard work.
Sincerely Linda

Linda,

Greetings

M.

#### Lindee

##### New Member
Hey Marcelo Branco,,,,I found a resolution to the issue of not being able to post the formula in the cells....I pasted the formula in the cell, then went to the formula bar, took out the = sign from the formula, then put the = sign in again and it WORKED it excepted the formula....I figured it out on my own ,,,very simple. Incase you have someone with the same issue. Still have the "Value Error" but that's ok, I found another formula... Thank you again for all your hard work.
Sincerely Linda
M, just wanted to update you with Great News,,, I was working with your formula,, I got it to work by changing the formating to General,,, used the little trick of removing the = sign and then replacing it in the formula bar and IT is now working GREAT. just wanted you to know you were on the right track. I used the evaluate formula when I posted it in the cell and Excel 10 said the cell was a "constant" (whatever that means) so I changed to General formatting.
Thank you M.
NEVER GIVE UP!!! that comes from
my Scottish heritage.
Thank you so much. I'd give you a hug but your a little to far away. lol
Linda PS. I would have never known any of this, if it wasn't for you and your patience.!!!!!!!

Last edited:

#### Marcelo Branco

##### MrExcel MVP
Linda,

Great news!

I'm very happy that the formula i suggested is working now and you figured out how to enter formulas.

All the best

M.