LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7
Default Change the format as data is entered

How can i enter data in excel in such a way that as I enter the format will
be changed.
For eg: when i enter 12345 the format should change to *****. This should
happen as I enter data and not after I enter data and hit enter
 
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 format changed when data entered John Keith Excel Discussion (Misc queries) 1 September 14th 07 06:04 AM
how to change format of several dates entered in an Excel column ilyaz New Users to Excel 2 August 1st 06 05:34 AM
Change source according to data entered in a template. ANStech Charts and Charting in Excel 1 March 29th 06 04:11 PM
?-Change data series range as data is entered? isofuncurves Charts and Charting in Excel 4 January 24th 06 06:15 PM
How do I change data that has been entered in a column to a row? ryoung Excel Discussion (Misc queries) 2 June 23rd 05 07:56 PM


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