zeroes as blanks (Why?)

BarrettM · Apr 2nd, 2002, 09:14 AM

I'm importing data from workbook A to Workbook B, but although the data in Workbook A has 0.00 in a cell, it appears as a blank cell in workbook B.
Also the formatting seem to be fine in workbook B.
I don't want this to happen, I want to see 0.00.

Any ideas?

Mark W. · Apr 2nd, 2002, 09:18 AM

Using the Tools | Options... menu command check the "Zero values" Window option on the View tab.

BarrettM · Apr 5th, 2002, 03:22 AM

Thanks Mark W

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 2nd, 2002, 09:14 AM	#1
BarrettM Board Regular Join Date: Mar 2002 Location: Northern Ireland Posts: 113	I'm importing data from workbook A to Workbook B, but although the data in Workbook A has 0.00 in a cell, it appears as a blank cell in workbook B. Also the formatting seem to be fine in workbook B. I don't want this to happen, I want to see 0.00. Any ideas?

Apr 2nd, 2002, 09:18 AM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Using the Tools \| Options... menu command check the "Zero values" Window option on the View tab.

Apr 5th, 2002, 03:22 AM	#3
BarrettM Board Regular Join Date: Mar 2002 Location: Northern Ireland Posts: 113	Thanks Mark W