LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Once a column is marked as $, how do I change it back?

I have a spreadsheet in which one column of data has been and should only be
calendar dates. All of a sudden now, when I type in a date (i.e., 12/1)
into this column, it comes out as 12. How can I correct this?
 
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 to change column labels back to letters? Camille Excel Discussion (Misc queries) 1 October 30th 08 01:16 PM
Somehow column headers changed to #'s, how do you change back? Sally Morgan Excel Worksheet Functions 2 October 6th 08 07:41 PM
How can change column title back to alphabet (A,B,C..) Ray Excel Worksheet Functions 2 March 9th 07 02:52 AM
How can I change column numbers back to column letters? Space Elf Excel Worksheet Functions 3 March 2nd 06 09:35 PM
How do i change column headings back to letters in excel? Chris Excel Discussion (Misc queries) 2 April 14th 05 02:10 PM


All times are GMT +1. The time now is 11:29 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"