cell format changed when data entered

J

John Keith

OK I've got another issue with data entry that I haven't seen before.
When I enter data into a cell that cell inherits the format of a cell
several rows above it (background color, horizontal center and set
font to bold.) Web searching using various descriptions of this
problem have not yielded any results. Any idea?


John Keith
(e-mail address removed)
 
G

Guest

hi,
just a guess but try this....
on the menu bar.....
Tools>options>edit tab>uncheck Extend list formats and formulas

regards
FSt1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

conditionl format overrides explicit format 2
Can macro test fill color in cell with conditional format? 3
cell contents not visible 5
conditional format cell 3
conditional format - put inside a for/next loop 8
Way to create a note based on the contents entered in a cell? 4
retain custom date format "text" when pasting or reformatting data 2
Delete row if column A cell text length is not 11 4

Top