Hi there,
I'm not good in coding. Appreciate if you could help me in this.
In excel 2010, column A1:A100 is a serial number where we manually feed numbers.
I want in A1 through A100 as 1PRAD when i hit numeric 1 in cell A1, 2PRAD when i hit numeric 2 in cell A2 and so forth...how can this be possible
regards,
Prad
yes, it is, bau attach a small sample file with data and desired result
If solved remember to mark Thread as solved
Give a try..
Select Cell A1:A100,
Go to Cell Formatting (Ctrl + 1)
Set Custom Cell Formatting as
0"PRAD"
Now start writing Number's in A1:A100
Regards!
=DEC2HEX(3563)
If you like someone's answer, click the star to give them a reputation point for that answer...
Hi, Prad,
if you really need a VBA solution, code goes behind the sheet (right click sheet tab, View Code and paste code into CodeWindow):
Ciao,
Please Login or Register to view this content.
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
It worked fantastic !!!! Thank you so much Debraj and Holger....what a solution!!
Last edited by meprad; 09-10-2013 at 05:05 AM.
Hi, meprad,
change the format to #"PRAD".
Ciao,
#Holger
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks