| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format of Cells
We have a spreadsheet that every dept inputs info into, about 65,000 lines.
It could be dates or numbers or blank. The format for all cells right now is DATE. Those that put in a "3" it converts it to a date. When we total below, the counts are messed up because of the formats. Is there a format that make dates =dates and numbers=numbers, blank = blank. Right now blank is also counted as a ZERO. Thanks for the help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why will my cells not format? | New Users to Excel | |||
| How can I find and format specific cells automatically in Excel? | Excel Worksheet Functions | |||
| Number format exactly the same, displays differently in some cells | Excel Discussion (Misc queries) | |||
| Make Alignment options under format cells available as shortcut | Excel Discussion (Misc queries) | |||
| format cells dialog box does not come up | Excel Discussion (Misc queries) | |||
Linear Mode
