| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
is it possible to make a spreadsheet display '0' when negative
i am creating a spreadsheet and want the value to be zero when negative is
this possible |
|
#2
|
|||
|
|||
|
is it possible to make a spreadsheet display '0' when negative
Use a format of General;"0";General
-- HTH RP (remove nothere from the email address if mailing direct) "atsoc" wrote in message ... i am creating a spreadsheet and want the value to be zero when negative is this possible |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I make a spreadsheet look more fun (eg add a cartoon) | Excel Discussion (Misc queries) | |||
| How can I make a login styled spreadsheet? | Excel Discussion (Misc queries) | |||
| How do I make all caps in a column of any spreadsheet? | Excel Discussion (Misc queries) | |||
| How do I make a water mark on an excel spreadsheet? | Charts and Charting in Excel | |||
| Display dates from an Excel spreadsheet in a calendar? | Excel Worksheet Functions | |||
Linear Mode
