Re: numer substitute with # on print




Ok. But why number are printed as #??? The cell is setting for "text"!

Formatting a number as "text" does not mean it's not a number.  If you
want to have a string in the cell, format it first and then enter the
text.

The primary function of "Text" formatting is to make sure texts like "01"
and "1/1/1" do not get interpreted as numbers or dates.

Morten



[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]