insert column default format same as right

Originally Posted by beginnerbob

I have 2 columns.

First column is a date column.
Second column is a currency column ($).

I would like to insert a column between them and have the format of this column by default be the same as the column on the right, ie the currency column.

I realise that I can get the format I need with Insert Options but can it be done that the inserted column by default can have the format of the column on the right rather than the left?

Hi,

you could do that with a macro, and trigger the Insert by Ctrl/Shift/I etc, the code would be something like

Please Login or Register  to view this content.

which you would need to paste into Tools, Macro. Macros (name the macro) Create.

hth
---