Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Excel Macro
Name: tommyvo Date: February 25, 2009 at 13:37:36 Pacific OS: Windows XP Subcategory: General
Name: paulsep Date: February 25, 2009 at 16:07:06 Pacific
Reply:
Do you need the macro or the cell format string. cell format string is: ##°##'##"."##
Please send a reply, if you solved the problem !!!
0
Response Number 2
Name: tommyvo Date: February 26, 2009 at 07:32:25 Pacific
Reply:
Sorry I a macro dummy. Can you please show me step by step in excel?
thank you
0
Response Number 3
Name: paulsep Date: February 26, 2009 at 09:19:03 Pacific
Reply:
You can simply create a macro by using the macro recorder.
In Excel do the following: 1. click Extras | Macro | Record 2. give you macro a name or accept the default 3. click ok 4. click the menu Format | Cells 5. choose category "user defined" 6. at the right side under Type, fill in ##°##'##"."## 7. click ok 8. click the stopp button of the little macro recorder window
That's it.
By the way, you can read by using Excels help function. So use the F1 key, whenever you need help.
Please send a reply, if you solved the problem !!!
0
Response Number 4
Name: OtheHill Date: February 26, 2009 at 10:32:35 Pacific
Reply:
In the future there is an Office Software forum here that would better serve questions about Excel.
Summary: Hi! Does anyone know what syntax to use in the Start menu, in the "Run" command when you want to execute a certain macro in a certain Excel file. The reason for asking is that I want to schedule a da...
Summary: I have a folder of 1000 or so Excel spreadsheets in which I need to update the formulas for a change in government levies. Is there any freeware or shareware that can modify Excel formula en-masse wit...
Summary: Hi I want to know how to record a macro to select SOME of the text within a cell (eg to automate pressing F2 followed Ctrl-Shift-Left Arrow to select the end word and then copying that). Then I want t...
0 
Inaccessible boot device
