Thank you for your answer and prompt response.

"T. Valko" wrote:

Is this possible?

No. By default all cells have a General format. This can be described as
basically "what you see is what you get". If you type in a number, it's a
number. If you type in text, it's text. In general, a lot of people cause
their own problems by "over formatting". They seem to think that if they
enter numbers in a cell then they have to format the cell as Number. Same
thing for text. This is not necessary.

--
Biff
Microsoft Excel MVP


"Treehugger" wrote in message
...
My spreadsheet has several data input cells. The data is later used in a
calculation. I don't want the input restricted by format or number of
decimal points. I want the spreadsheet to display whatever the user types,
so
I used the General format. A co-worker is concerned that Excel may
misread
the numbers as text values unless they are specifically formatted as
numbers.
Is this possible?