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!

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

blanks coming in as zeros

Status
Not open for further replies.
tennis

tennis

Technical User
Aug 23, 2001
18
US
Hello,

I have a linked worksheet where the table data has data that contains blanks; however, when I link that to a formatted worksheet the blanks now appear as zeros.

How do I link that data and have the blank fields come in as blanks.....not zeros?

Thank you
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

grnzbra
  • Locked
  • Question
Prevent Leading Zeros in Excel
Replies
9
Views
165
SkipVought
S
BugZap13
  • Question
Excel formula to count occurrences of a value in a different sheet
Replies
5
Views
483
bs6600
bs6600
Cpreston
  • Locked
  • Question
Trim Multiple items in one column
Replies
2
Views
232
Andrzejek
Andrzejek
Andyri
  • Locked
  • Question
Limits in Excel 2
Replies
7
Views
271
Andyri
Andyri
grnzbra
  • Locked
  • Question
Force Data Entry Format in Excel
Replies
10
Views
297
combo
combo

Part and Inventory Search

Sponsor

Back
Top