PC Review


Reply
Thread Tools Rate Thread

convert range numbers to letter

 
 
JB
Guest
Posts: n/a
 
      1st Mar 2006
Hello.
I hope this makes sense.
I have a spreadsheet that has columns with numbers ranging from 1 to 100.
I would like to convert them to letters
i.e. 90 - 100 = A
80 - 90 = B
70 - 80 = C
60 - 70 = D and so on
Is this possible?
Thank you
JB


 
Reply With Quote
 
 
 
 
Rick B
Guest
Posts: n/a
 
      1st Mar 2006
This is an Access newsgroup. Spreadsheet is an Excel term.

Please post your question to an Excel newsgroup.

--
Rick B



"JB" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hello.
> I hope this makes sense.
> I have a spreadsheet that has columns with numbers ranging from 1 to 100.
> I would like to convert them to letters
> i.e. 90 - 100 = A
> 80 - 90 = B
> 70 - 80 = C
> 60 - 70 = D and so on
> Is this possible?
> Thank you
> JB
>
>



 
Reply With Quote
 
JB
Guest
Posts: n/a
 
      1st Mar 2006
Really sorry, I clicked the wrong NG on my subscription list.
doh!

"Rick B" <Anonymous> wrote in message
news:(E-Mail Removed)...
> This is an Access newsgroup. Spreadsheet is an Excel term.
>
> Please post your question to an Excel newsgroup.
>
> --
> Rick B
>
>
>
> "JB" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> Hello.
>> I hope this makes sense.
>> I have a spreadsheet that has columns with numbers ranging from 1 to 100.
>> I would like to convert them to letters
>> i.e. 90 - 100 = A
>> 80 - 90 = B
>> 70 - 80 = C
>> 60 - 70 = D and so on
>> Is this possible?
>> Thank you
>> JB
>>
>>

>
>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
convert a range of text into numbers =?Utf-8?B?RmFib2JvcmVu?= Microsoft Excel Programming 11 8th Nov 2007 09:14 PM
convert range of numbers in one record into range of single-number records shadowsong@gmail.com Microsoft Access Queries 15 28th Jul 2007 02:39 AM
assigning a letter in a cell from a range of numbers in another ce =?Utf-8?B?ZGJh?= Microsoft Excel Programming 2 23rd May 2007 04:43 PM
Convert range of numbers to letter JB Microsoft Excel Discussion 10 2nd Mar 2006 10:33 PM
Convert column letter to numbers Todd Huttenstine Microsoft Excel Programming 3 8th Mar 2004 07:49 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:16 AM.