Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Referencing Cells
Hi,
I have several columns with dates and text. For example. 1B text 1C date 1D date 1E text 1F date Sometimes the fields are blank. When I reference the cell, if they are blank, the text fields come up with a 0 and the dates are o-jan-00. I then have to reformat each time. Is there a way to not have to reformat each time. Return blanks, when they are blank. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Referencing other cells | Excel Discussion (Misc queries) | |||
Vlookup? Referencing cells? | Excel Worksheet Functions | |||
Referencing cells | New Users to Excel | |||
Referencing Cells Using If Functions | Excel Worksheet Functions | |||
Referencing Cells | Excel Worksheet Functions |