Date/Serial Number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hoping you can help me quickly.

I exported a report from QuickBooks to Excel. Everything exported correctly and I am manipulating how the report looks. All of a sudden (and I don't know what I did), the Date column (defined as Custom by QB mm/dd/yyyy) is appearing in the display as the serial number.

The display line on the top of my screen (underneath my standard toolbar) displays the date correctly. How can I get my workcells to display the date again? I've tried to change the formatting, etc., but it continues to display the serial number in the workcell.

THanks, Sally
 
not sure but look at the dates on the edit bar under the
icons (not in the cell) If a hidden single quote mark is
there, then some how the data got changed to text.
solution: remove the hidden single quote mark. no easy
way. have to do it manually.
-----Original Message-----
Hoping you can help me quickly.

I exported a report from QuickBooks to Excel. Everything
Click to expand...
exported correctly and I am manipulating how the report
looks. All of a sudden (and I don't know what I did), the
Date column (defined as Custom by QB mm/dd/yyyy) is
appearing in the display as the serial number.
The display line on the top of my screen (underneath my
Click to expand...
standard toolbar) displays the date correctly. How can I
get my workcells to display the date again? I've tried to
change the formatting, etc., but it continues to display
the serial number in the workcell.
 
Hoping you can help me quickly.

I exported a report from QuickBooks to Excel. Everything exported correctly and I am manipulating how the report looks. All of a sudden (and I don't know what I did), the Date column (defined as Custom by QB mm/dd/yyyy) is appearing in the display as the serial number.

The display line on the top of my screen (underneath my standard toolbar) displays the date correctly. How can I get my workcells to display the date again? I've tried to change the formatting, etc., but it continues to display the serial number in the workcell.

THanks, Sally
Click to expand...

What exactly is this "serial number" to which you refer.

If the number is something like 38712, then you need to format your Excel
column as Date (see Format/Cells/Number/Date and pick one of the formats, or a
custom format).

If that is not the serial number, then tell us what you mean by that.\


--ron
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Converting a 10 digit serial number to a date of mm/dd/yyyy 7
How do I change the serial date to a dd/mm/yyyy format 4
Excel 2002: How to make the date format uniform ? 1
generate serial numbers and date it entered 3
Excel 2007 displayed dates 2
Date Formatting Error 1
convert serial date format to normal date format 3
counting records by month and year / date format issues 1

Back
Top