ExcelBanter - Why todays date shows up as #### in excel doc.

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Why todays date shows up as #### in excel doc. (https://www.excelbanter.com/excel-discussion-misc-queries/134809-why-todays-date-shows-up-excel-doc.html)

halfpint

Why todays date shows up as #### in excel doc.

I am trying to change the date in a cell that I am working on in an excel
worksheet. While typing, the date shows as it should 14 Mar 07; however,
after "entering" the numerals change to ######. What is going on here? We
are using the latest XP version.

Toppers

Why todays date shows up as #### in excel doc.

Adjust column width.

"halfpint" wrote:

I am trying to change the date in a cell that I am working on in an excel
worksheet. While typing, the date shows as it should 14 Mar 07; however,
after "entering" the numerals change to ######. What is going on here? We
are using the latest XP version.

hellsbells

Why todays date shows up as #### in excel doc.

you need to expand the column - the symbols just indicate that there isnt
enough space.

"halfpint" wrote:

I am trying to change the date in a cell that I am working on in an excel
worksheet. While typing, the date shows as it should 14 Mar 07; however,
after "entering" the numerals change to ######. What is going on here? We
are using the latest XP version.

All times are GMT +1. The time now is 03:02 AM.