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.
--
Rod
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
