| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Show value 0 in blanks fields
Hi,
I have the following field: PERIODS: "PERIOD" & "" & " " & [PERIOD], which works fine. But I want to put a Zero (0), where there is no data. I tried PERIODS: "PERIOD" & "" & " " & Nz([PERIOD],"0") But doesn't seem to work. Am I doing something wrong? Please advise any info. Thank you, Juan |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| fields names do not show in excel 2007 pivot table fields list | New Users to Excel | |||
| Auto update a list and don't show blanks | Excel Worksheet Functions | |||
| Show Non Blanks using MS Query | Excel Discussion (Misc queries) | |||
| Update fields with blanks | Excel Discussion (Misc queries) | |||
| Import - query table - retain trailing blanks in fields | Excel Programming | |||
Linear Mode
