RE: $$Excel-Macros$$ Hash Hash appearing in formula

2012-04-14 Thread Rajan_Verma
Press Shift + Ctrl + ~ Rajan From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of hilary lomotey Sent: Apr/Sat/2012 06:16 To: excel-macros Subject: $$Excel-Macros$$ Hash Hash appearing in formula Hello Experts Attached is a call report i have

Re: $$Excel-Macros$$ Hash Hash appearing in formula

2012-04-14 Thread hilary lomotey
thank chief, it works On Sat, Apr 14, 2012 at 1:02 PM, Sam Mathai Chacko wrote: > Custom format the cell to "0" > > Regards, > Sam > > > On Sat, Apr 14, 2012 at 6:16 PM, hilary lomotey wrote: > >> Hello Experts >> >> Attached is a call report i have created. Where you can choose a >> department

Re: $$Excel-Macros$$ Hash Hash appearing in formula

2012-04-14 Thread Sam Mathai Chacko
Custom format the cell to "0" Regards, Sam On Sat, Apr 14, 2012 at 6:16 PM, hilary lomotey wrote: > Hello Experts > > Attached is a call report i have created. Where you can choose a > department from the drop down and see the call report for that dept. The > problem am facing is that some of

$$Excel-Macros$$ Hash Hash appearing in formula

2012-04-14 Thread hilary lomotey
Hello Experts Attached is a call report i have created. Where you can choose a department from the drop down and see the call report for that dept. The problem am facing is that some of the words typed into the discussion details are very long so when you choose that particular client name it sho