Re: $$Excel-Macros$$ format cell

2012-04-05 Thread NOORAIN ANSARI
Dear Pawel, You can also use VBA Approach.. select required range and run this macro.. Sub Format_Cell() For Each cell In Selection Selection.NumberFormat = """R""@" Next cell End Sub -- Thanks & regards, Noorain Ansari *http://noorainansari.com/* *http://excelmacroworld.blogspot.com/*

Re: $$Excel-Macros$$ format cell

2012-04-04 Thread Seraj Alam
Hi, U can also try ="R"&A1 On Wed, Apr 4, 2012 at 2:07 AM, pawel lupinski wrote: > Hi All, > Can you help me with cell format I need to format it in the way that > should change input "0204177" to "R0204177", but the difficult of my is > that number of digit can be vary from 6 to 7. Please see

Re: $$Excel-Macros$$ format cell

2012-04-04 Thread pawel lupinski
: $$Excel-Macros$$ format cell Hi Pawel, You can use the following number format: \R@ That formats the cells as text and includes the leading R.  Type as manby digits as you like, including leading zeroes, and they will be preserved.   Asa   From:excel-macros@googlegroups.com [mailto:excel-macros

RE: $$Excel-Macros$$ format cell

2012-04-04 Thread Asa Rossoff
Behalf Of pawel lupinski Sent: Wednesday, April 04, 2012 2:07 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ format cell Hi All, Can you help me with cell format I need to format it in the way that should change input "0204177" to "R0204177", but the difficult

Re: $$Excel-Macros$$ format cell

2012-04-04 Thread Amresh Maurya
USE THIS. Shortcut Keys - ALT+D+E>NEXT>NEXT>TEXT>GENERAL then Cntl+1>custom>Type"\R00">OK. Regards Amresh On Wed, Apr 4, 2012 at 2:13 AM, Amresh Maurya wrote: > Hi Pawal, > > please find the attached solution. > > kindly use text to column.- ALT+D+E>NEXT>NEXT>TEXT>ENTER > > Regards > A

Re: $$Excel-Macros$$ format cell

2012-04-04 Thread Amresh Maurya
Hi Pawal, please find the attached solution. kindly use text to column.- ALT+D+E>NEXT>NEXT>TEXT>ENTER Regards Amresh On Wed, Apr 4, 2012 at 2:07 AM, pawel lupinski wrote: > Hi All, > Can you help me with cell format I need to format it in the way that > should change input "0204177" to "R

$$Excel-Macros$$ format cell

2012-04-04 Thread pawel lupinski
Hi All, Can you help me with cell format I need to format it in the way that should change input "0204177" to "R0204177", but the difficult of my is that number of digit can be vary from 6 to 7. Please see inside the file. Regards, Pawel -- FORUM RULES (986+ members already BANNED for violation