Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Number formatting - not working in some cells

Status
Not open for further replies.

Maisie2007

Technical User
Apr 12, 2007
42
CA
Hi,

I have got some cells with "General" number formatting with nothing showing in the sample.

Then, other cells are showing a "0" in the sample, and this is with the "General" ticked off.

I don't want anything to show up in the cells if I tick off "General"

Would anyone know what might be wrong?

Thanks!
 




Hi,

I wouldn't "tick off" the General. ;-)

You really have not proveded enough pertinent information.

What is "the sample?"

"nothing showing in the sample" What is ACTUALLY in the CELL that is not showing?

"Then, other cells are showing a "0" in the sample, and this is with the "General" ticked off." What is ACTUALLY in this cell?

"I don't want anything to show up in the cells if I tick off "General"" That is not possible without special VBA coding.







Skip,

[glasses] When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large[tongue]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top