Locking or Fixing the Format of columns

albita09

New member
Joined
Jan 30, 2014
Messages
13
Reaction score
0
Points
0
Dear all once more,

This time I am writing to ask about cell formating:

I would like, in my excel sheet, to have COLUMN C, D and E as text no matter whether I insert rows or I past cells form another doc etc..

Is there liek a magic option to fix that, maybe under a password?

Thank you so much for your help!

A.
 

Sixthsense

New member
Joined
Nov 6, 2012
Messages
26
Reaction score
0
Points
0
Location
India
Make use of Worsheet Events to format those columns add/del to format as text.
Use Paste Special Values/Text whenever pasting the data in those columns to keep the data as text.
 
Top