Excel Tips - Toggle Date Format

Hey,

Has anybody noticed that all the help sections of the date/time help in excel tips is missing any information that's normally there?

just thought I would mention it.


oliver.

Thanks to all beforehand. I am in need of excel formula or VBA Code to change date format from 05-30-2010 into 30-05-2010. Actually every month I received excel dump from different companies in which I received date format as given above as premium due date, I used different different excel formulas but not able to change its format into proper excel format. Kindly help me resolving this problem.

I used to use text to column then adding them using this formula =date(year(a1),month(a2),day(a3)). But rather I want formula or code for this solutions.

Excel sameple sheet is attached for reference.


Regards,
Pramod Kumar

I'm trying to create a macro that will allow me to toggle a number fromat between containing a comma and not containing a comma. I work with a ton of excel ws that need to move into sql so I prefer to remove the comma from the integers. So far this code doesn't work all the way. how can I tweak it?

Sub NumberFormat()
If Selection.NumberFormat = "#,##0" Then Selection.NumberFormat = "0_);(0)"
If Selection.NumberFormat = "0_);(0)" Then Selection.NumberFormat = "#,##0"
End Sub

Hi im reletivley new to this forum and excel and was wondering if there is anyway i could set a checkbox to change cells to their original format. What i mean by that is i have made a weekly sales spreadsheet showing stock sold ect and used conditional formatting to change the value colour if the value is either below 12, between 12-25 and 26+. So i was hoping that i could make a checkbox which when pressed could restore those modified cells to the original font and format????


Please Help

Thx in advance

Jordan

I have a toggle button which selects text values from a column on a worksheet on the first click and places the values in a listbox. When clicked again, it selects values from a different worksheet column and places them in the same list box (after clearing the previous values). I have never used the Conditional Formatting functionality and not sure what the code is to have the text values, selected on the first click of the toggle button, to show up as green text in the list box, and then on the second click the text values are red.

Need some coding help. Thanks

Hi All,

I am trying to combine the 2 macro strings below.
This is to change the font colour in a range of cells so as to hide the inputs and then unhide them when toggle button is unclicked.

Any recommendations on a shorter line of code would be much appreciated.

Thanks

Code:

Private Sub ToggleButton2_Click()
If ToggleButton2.Value = True Then

    Range("A9:A" & Cells(Rows.Count, 1).End(xlUp).Row).Select
    With Selection.Font
        .FontStyle = "Regular"
        .Size = 10
        .Strikethrough = False
        .Superscript = False
        .Subscript = False
        .OutlineFont = False
        .Shadow = False
        .Underline = xlUnderlineStyleNone
        .ColorIndex = xlNone
      ' or .ColorIndex = 2
        
    End With
End Sub




Private Sub ToggleButton2_Click()
If ToggleButton2.Value = False Then

    Range("A9:A" & Cells(Rows.Count, 1).End(xlUp).Row).Select
    With Selection.Font
        .FontStyle = "Regular"
        .Size = 10
        .Strikethrough = False
        .Superscript = False
        .Subscript = False
        .OutlineFont = False
        .Shadow = False
        .Underline = xlUnderlineStyleNone
        .ColorIndex = xlAutomatic
        
    End With
End Sub

I would like to write a macro that after hitting a shortcut key will change the format of a cell to a date - however.. if the cell is already a date, I would like the same shortcut to transfer it into integers. Sound possible?!

Thanks!!

I have been working in a worksheet with 10 tabs, and suddenly all of my numbers turned to long date format. I manually changed them all back to what they were. General, Currency, %, etc. but the default seems to be stuck in the long date format. When I create a new tab it is automatically all long dates. Very strange.
Oh, and the other weird thing is when I send it to other people, some people see the correct formats and when other's open it the numbers all go back to the long date format. VERY Frustrating.
Would love to get some advice.

What is the easy way to create forms in different sheets.......

In Main Sheet (Sheet1) each row contains some informations about a particular item.
I want to create Forms in separate Sheets and datas for this Form 1 (Sheet2) should be datas of Row#1 of Sheet1 & datas for this Form 2 (Sheet2) should be datas of Row#2 of the Sheet1.......

Hi Guys,
Does anyone know of a web site which offers Excel tips and tricks.
Is there a free book which I can download that will give me tips and tricks.
Thanking you in advance,
Regards

J-O