Excel Tip – The Format of an Inserted Column

January 28, 2020

Un-beknown to most, when you insert a new column, the Format of the cells in the Column are of the cells in the Column on the Left. So, if you get a Date when you enter a number as with the example shown, you would have inserted the column to the right of a Date Formatted Field.

 

This can be useful if that was your intention, but most of the time it isn’t. To override this default, use the Insert Options (little Paintbrush) to change the Format; either to the Column on the right or Clear the Formatting altogether.

 

Share on Facebook
Share on Twitter
Please reload

Featured Posts

I'm busy working on my blog posts. Watch this space!

Please reload

Recent Posts
Please reload

Archive
Please reload

Search By Tags
Please reload

Training Offices:

Johannesburg

106 Johan Avenue, Sandton

Durban

1 Tamarind Close, Umhlanga

Pietermaritzburg

400 Old Howick Road, Hilton

Corporate Onsite Training Available Countrywide

  • Summit Solutions Excel Training
  • Summit Solutions Excel Training
  • Summit Solutions Excel Training

Tel: 086 167 3923

Email: info@summitsolutions.co.za 

Head Office: Hilton Quarry Office Park, 400 Old Howick Road, Hilton.

2020 | Copyright | Summit Solutions