LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 48
Default Convert number to letter 123 to ABC

Hello Experts,

(I've previously asked this question but didnt get any replies.)

At my shop I'm printing product labels from an Excel sheet.

I'd like to add the cost field to the label but that would allow everyone to
figure my cost for the item.

So I thought of encoding the cost filed as the following:

0 = Z
1 = A
2 = B
3 = C
..
..
9 = I

So if the cost in a cell is (322.40) it would translate to (CBB.DZ).

Any ideas?

Thanks in advance
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Convert Letter to Number ExcelMS Excel Worksheet Functions 2 May 24th 08 04:47 PM
Convert a letter to a number sross002 Excel Discussion (Misc queries) 2 October 14th 06 02:04 AM
convert column number to letter Gord Dibben Excel Programming 1 October 31st 05 03:39 PM
convert column number to letter lvcha.gouqizi Excel Programming 1 October 24th 05 09:37 PM
How do I convert a given number into a letter? vortex0001 Excel Worksheet Functions 5 September 8th 05 10:09 AM


All times are GMT +1. The time now is 02:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"