Home » Blogs » 4998275DL's blog

HELP ???

Submitted by 4998275DL on 14 January, 2012 - 19:53

I'm new at using Excell. I'm trying to assign a numerical value to a letter in my spreadsheet.Can you walk me thru step by step? Or do you have a Video? Thanks

»

Try to maintain a reference

Submitted by Anonymous on 2 April, 2012 - 10:44.

Try to maintain a reference Sheet with the Alphabet and its numeric equivalent. USe the Vlookup function to retreive the numeric equivalent and sum them..

If needed you could hide the reference sheet.

»

applying formula

Submitted by Anonymous on 21 January, 2012 - 14:22.

I'm trying to replace numerical values in a row with text(letters). How is this done?

»

pls give an exampledo you

Submitted by Nick (not verified) on 22 January, 2012 - 15:28.

pls give an example

do you mean:

20
goes to:
Twenty

?

»

You can blog or

Submitted by 4998275DL on 14 January, 2012 - 19:55.

You can blog or e-mail...thanks

»
Nick's picture

hi don't understand the

Submitted by Nick on 14 January, 2012 - 21:37.

hi
don't understand the question
pls clarify

»

I"m trying to use the letter

Submitted by 4998275DL on 15 January, 2012 - 13:31.

I"m trying to use the letter 'S' in a cell,to represent 8hrs. for that day... so when the sum is totaled,it will give me a numerical total...

S+S=16

S+S+S= 24

How do you make S represent 8 or any other value?

Mark
I also need to enter information in certain cells on one sheet in a workbook,automatically transfer to the other sheets? Thank you...

»
Vishesh's picture

Solution

Submitted by Vishesh on 15 January, 2012 - 15:02.

Check this url
http://excelexperts.com/answer-blog

»

Thanx form the formula..I

Submitted by 4998275DL on 17 January, 2012 - 12:29.

Thanx form the formula..I have it working on the sheet,but I cant get it to apply to certain cells?I'm new at this so it's 'French' to me? I'm trying to figure out how to send you a copy of my schedule that its applying to,and maybe that will help you explain it to me?

»