Format cell to show '-'
This only changes the appearance of the number, not its function.
Gary
"rslc" wrote:
"Gary" wrote in message
...
Looking for a way to make entries into cell show negative (-) indicator by
default. For instance if '1' is entered, it will display '-1'.
Excel 2003
you can right click the cell and use the format menu format cells on number
tab click custom and in the type box enter -0 then ok. you can copy format
to as many cells as you like
cheers
rslc
ps i use something similar to display temperature in celcius
|