LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2
Default Keyboard Formatting of a Cell

In another spreadsheet program long ago, it was possible to type an
apostrophe preceding text that is being entered into a numbers-formatted
cell, the the text was treated as text. For example, in Excel 2003, if I
type "04/04/08" in a General cell, Excel converts the entry to
"4/4/2008". If I typed "'04/04/08" (an apostrophe precedes the numbers
and slashes), the information was entered as text as if the cell were
separately formatted for text. Is there is similar capability in Excel?
 
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
Cell Reference Keyboard Shortcut unavailable Mike Excel Discussion (Misc queries) 1 June 6th 08 11:18 PM
Center text in Excel 03 cell by using the keyboard? tarebare Excel Discussion (Misc queries) 3 May 22nd 08 09:50 PM
Excel 03 keyboard move to next cell? Punkin Excel Discussion (Misc queries) 4 April 27th 06 08:19 PM
Keyboard Command to go to next blank cell Debra Farnham Excel Discussion (Misc queries) 2 October 4th 05 08:27 PM
Is there a keyboard shortcut to center data in a cell? Phil_K Excel Worksheet Functions 1 April 24th 05 01:55 AM


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