Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
papacradd
 
Posts: n/a
Default 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?
  #2   Report Post  
JE McGimpsey
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can i set consecutive columns in an excel worksheet to differ. Adam H Charts and Charting in Excel 2 February 25th 05 11:08 PM
hide column but show chart Svetlana Charts and Charting in Excel 1 January 14th 05 09:49 AM
Column A is Town, Column B is names. How can Excel add & tell how. Cindy Charts and Charting in Excel 3 January 13th 05 07:27 PM
How do I sort a column of formulas in Excel? Gordon Excel Discussion (Misc queries) 2 November 27th 04 01:55 AM
How do I sort a column of formulas in Excel? Gordon Excel Discussion (Misc queries) 0 November 26th 04 03:19 PM


All times are GMT +1. The time now is 06:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"