On Wed, 2006-02-08 at 08:53, Randomthots wrote: > Glen wrote: > > > I am doing a spreadsheet and am trying to do what Microsoft calls > > "masking" in a cell. I will give 2 examples > > > > First example > > I have a date cell and it is using the standard of 02/07/06 . > > I want to make it so that when I start the cell I see the slashes and I > > don't need to put them in and it goes from the 02 to the 07 without me > > having to manually putting the slashes in. > > > > Second example > > I have a time cell that uses 09:28. I want to be able to put in 0928 > > and it separate it out without me having to put the : in manually. > > > > This is probably in the help somewhere and I am just not seeing it > > Thanks for your help > > Glen > > [EMAIL PROTECTED] > > > Nope. It's not in the Help because it's not something that Calc will do. > There is an open issue requesting this feature: > > http://www.openoffice.org/issues/show_bug.cgi?id=47906 > > Personally, I don't find it that bad with dates because the slash key is > at least on the numeric keypad, but inputing time values is a big pain. > Not only is the colon not on the keypad but it's a *shifted* character > for the love of Pete! > > I'll tell you what I usually do... if I'm creating a spreadsheet with a > time column, I'll just make separate columns for the hours, minutes, and > seconds and then a last column that combines it all using the time() > function. The syntax is time(hours;minutes;seconds). > > But I wholeheartedly agree with you. And an enhancement like this should > be generalized so that you could use it for things like telephone > numbers, social security numbers, product codes, etc. Could use more votes, only 7 when I last checked. -- Fred
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]