Posts by svenjafour

Re: Envelopes Options - Default Settings

Thank you very much!

I am trying to set a new default in the envelopes options, but have been unsuccessful. I am able to set a new default for the return address font, as well as the recepient's address font, but I cannot permanently change the left and upper alignment of either, return address and recepient's address. Every time I close Word and open it back up, my alignment setting are changed back to "auto". Does anyone have a solution for this problem? Thank you so much for your help!

Svenja

Re: Automatic Time Format

I tried the following formula to convert my values and then set it to the "time" format. It works for this.

=TIMEVALUE(INT(A1/10000)&":"&INT(MOD(A1,10000)/100)&":"&MOD(A1,100))

Thank you for all your help and time. I do need to take some VBA classes - I'd love to know more. Y'all have a wonderful day and Happy Holidays!

Svenja

Re: Automatice Time Format

Thank you so much for your help!!! I tried it with the code and it worked once, then I tried to copy the time into column B and I got a runtime error code with a "debug". I just started over and tried again, but this time it won't work. Is there a way to do it where I can enter the data in column B instead of A? And what did I do wrong that it is not working now? Thank you so much again for your time and effort!

Svenja

Re: Automatic Time Format

Thank you, that helps me in the right direction. I would really like to have the semi-colon between the numbers to get the real time format. I am going to have to enter tons and tons of time data and this formula would help me speed up the data entry tremendously. Thanks again everybody and please let me know if you'll find out how to fix this.

Svenja

I am struggling with an automatic time format in Excel. I would like to type in the following:

064808

and automatically receive

06:48:08

I tried to use the "format" "cells" "time" format, but all I receive is this when I type in the above:

0:00:00

I feel like an idiot...l does anyone know what I am doing wrong?

I would appreciate any help with this soooo much!!!

Svenja

Re: Form Field Format to SSN

I guess I just found out how to do it

The format should be ###-##-####
I kept trying 000-00-0000 or 000'-'00'-'0000, which did not work.

Hi everyone:

I am trying to format my form field in MS Word to automatically put a 9 digit number into the Social Security Format. For example:

If someone enters 235468874, I want it to automatically appear as
235-46-8874

Can anybody help me formatting this? Thank you so much for your help!!!

I used yours

Yipeee, it worked!!! Thank you 10000 times!

Thank you very much for the postings. Unfortunately, I have no idea how to use VBA Is there another way?

Hey guys,

I am trying to get the file path to show up in the footnote of my spreadsheet. There are buttons for page number, file name, sheet name, etc. - so that's no problem. I just cannot figure out how to get the file path to show up. I would like the file path and the file name in the footnote. Can anyone help me? Thank you in advance!

Svenja

Thank you so much!

thank you so much!!!

Hey there,

I have a phone list on an excel sheet and I would like for every odd row (like row 1, 3, 5, 7, etc.) to be grey and every even row to stay white. How can I do that?

How do I convert a certain time (ex. 2.14pm, 9.12am, etc.) to just minutes, so I can calculate with it?

thank you very much! Worked great with the format.

Svenja

‘‘’ instead of 0

I have an excel sheet where I copy a few cells to another place, using the command C51=C4, etc… Now, if there’s no value in field C4, a “0” appears in field C51, but I want it to be just empty, no value, just blank. Can anybody help me with this, please? Thank you in advance.

Svenja

this is weird... I just got a brandnew DELL computer today (with flat screen and such, but that's beside the point) and I printed a two page document. Guess what... it didn't do the silly "page 1 of 1 on the first page and page 2 of 2 on the second page" anymore. I wonder what was wrong with my last computer. I could swear it must have been some kind of a wrong setting. But anyway, now it works the way it should and I'll probably never find out why...
Thank you again everyone who tried to help me with this.

Svenja

please HELP