Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Using excel 2003, I am trying to create a worksheet in which the first column
records the dates of purchases and sales, the details of which are then recorded in the corresponding row. I keep getting a series of symbols, which usually indicate an incorrect formula. I don't want a formula, just a date. Can anyone please advise how I can do this, as the office assistant and m/s online dont seem to understand my question? |
#2
![]() |
|||
|
|||
![]()
Are the symbols ####? In that case, widen the column, or choose a
different date format. In article , papacradd wrote: Using excel 2003, I am trying to create a worksheet in which the first column records the dates of purchases and sales, the details of which are then recorded in the corresponding row. I keep getting a series of symbols, which usually indicate an incorrect formula. I don't want a formula, just a date. Can anyone please advise how I can do this, as the office assistant and m/s online dont seem to understand my question? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can i set consecutive columns in an excel worksheet to differ. | Charts and Charting in Excel | |||
hide column but show chart | Charts and Charting in Excel | |||
Column A is Town, Column B is names. How can Excel add & tell how. | Charts and Charting in Excel | |||
How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) | |||
How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) |