ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how do I show dates in a column in an excel worksheet? (https://www.excelbanter.com/excel-discussion-misc-queries/1490-how-do-i-show-dates-column-excel-worksheet.html)

papacradd

how do I show dates in a column in an excel worksheet?
 
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?

JE McGimpsey

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?



All times are GMT +1. The time now is 07:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com