Hi Martin,
Please send the file.. that'll be easy to see the problem.
Regards,
Sri
On Wed, Jun 24, 2009 at 9:13 PM, mnutty wrote:
>
> I have a user who after running a macro, has strange formatting
> applied to cells in any subsequent workbooks opened in the same Excel
> session. When I select
Hi Nourredine,
Just insert a column next to your invoice amount date and use =round(cell
name,2).
Use this new cell reference in your mail merge. That'll do
Cheers,
Sri
On Thu, Jun 25, 2009 at 6:48 PM, NOURREDINE BELHAJ <
nourredine.bel...@gmail.com> wrote:
> Hi All,
>
> Hope you are all fine.
Hye All,
Inserting rows and columns is a daily exercise for Excellers!!
Crtl+Space and then Ctrl and + to insert columns
Shift+Space and then Ctrl and + to insert columns
That'll do a lot of wonders.
Best Regards,
Sri
On Fri, Jun 26, 2009 at 8:49 PM, Ayush Jain wrote:
>
>
> Hello Members,
>
Hi Subu,
use the function =proper(cell)
e.g., it will be =proper(A2), if your text is in A2.
*Sri*
On Wed, Jun 24, 2009 at 1:40 PM, Subu wrote:
>
> Dear List members and XL Gurus
>
> I have an XL sheet with a column that looks something like
>
> Name_One
> nAme_two
> NAME_THREE
> name_four
>
Hi,
Keep the range fixed, countif($a$2:$a$10,"M") should work with M or F.
Sri
On Sun, Jun 7, 2009 at 5:24 PM, Ramesh Katta wrote:
> Dear Members,
>
> My question seems to be very simple, please don't laugh at me.
>
> I have 2 columns that are A1 contains Names and B1 contains Sex of
> employe
It works for the entire work sheet
SRI
On Mon, Jun 8, 2009 at 3:31 PM, Manoj S Negi <
manojsnegi.uttranc...@gmail.com> wrote:
> Hi Ramesh,
>
> Thanks for the tip but its showing the formule of current cell only not for
> entire work sheet.
> Is there any another way to use this tip Kindly sha
to copy just the formula.. copy it from the formula bar.
Ctrl + D - to copy the cells from top to bottom (the last cell that you have
your cursor on)
Ctrl + C and CTRL +V - copy and paste "all" - which means formula,format
etc..
*Sri*
On Tue, May 12, 2009 at 12:02 PM, Yu wrote:
>
> Hi All,
>
>
