stop (1) from turning into -1
 

How do I stop (1) from turning into -1.

Type an apostrophe '
before typing: (1)

Or pre-format the cells as text
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Ferral" wrote in message
...
How do I stop (1) from turning into -1.

if you want it to remain numeric
<fromat<cell<number Select custom
#,##0;(#,##0)

"Ferral" wrote:

How do I stop (1) from turning into -1.