Search:

Type: Posts; User: Oh!Calcutta; Keyword(s):

Search: Search took 0.00 seconds.

  1. Replies
    1
    Views
    158

    Date Formatting

    Hi All!

    My issue is that I have to put dates in dd/mm/yyyy formats in Excel worksheets as per Govt Requirements. When those sheets are imported in a Java Utility (prepared by Govt Agency &...
  2. Replies
    2
    Views
    21,122

    Re: Custom Format Add Ins or VBA Codes

    Dear Shahzadt,

    Thanks.

    I frequently need to summarize financial data as per clients' requirements hence my questions.
  3. Replies
    2
    Views
    21,122

    Custom Format Add Ins or VBA Codes

    Hi Excellers!

    Could anyone please tell me the VBA codes for the following Custom Formats in Excel 2010:
    (1) ##\,##\,##\,##0.00;[<-999999](##\,##\,##0.00);##,##0.00

    (2) #,##0.00,,

    (3)...
  4. Replies
    3
    Views
    406

    Re: Custom No. Formatting

    Dear Venkat,

    Thanks very much it works.
  5. Replies
    3
    Views
    406

    Custom No. Formatting

    Hi Excel Bosses!

    Greetings!

    Could you please tell me how to format Currency figures in Millions or Billions or Lacs or Crores?

    Thanks.
  6. Replies
    1
    Views
    2,741

    Formatting Bill Register

    Hello All!

    Greetings.

    Pls help me to format our Bill Register so as to enable us to automatically see the amount of daily bills issued, daily payments received & outstanding amounts.

    Our...
  7. Replies
    1
    Views
    148

    Conditional Formatting

    Hello All!

    Please help me in solving my problem.

    I have a data set as follows:
    Col A = Customer ID
    Col B = Customer Name
    Col C = Customer Address
    Col D = Customer ZIP / PIN
    Col E = Invoice...
  8. Replies
    5
    Views
    142

    Re: Text Formatting

    Dear Rick,

    Thanks very much. Your assumption of Address in Column C is accurate! I omitted to mention the same. Hats off to you!

    :eeek:
  9. Replies
    5
    Views
    142

    Re: Text Formatting

    Thank you Firefly & Rick, for your prompt replies.
    I have 2 address columns (1 for full postal address & the other for ZIP Codes) in the worksheet. I do have a header row which I don't want to...
  10. Replies
    5
    Views
    142

    Text Formatting

    Hi All!

    Can you help me to write a Macro for texts (Address field) to be formatted in UPPER case only?

    Thanks in advance.

    :eeek:
  11. Replies
    1
    Views
    202

    Importing Txt File & Formatting it

    Hi All!

    Can u help me in formatting a txt file imported in Excel 2007 retaining the original file structure? The file is showing '.gz' as extension. I could not open the file for copying & pasting...
  12. Replies
    3
    Views
    138

    Re: Conditional Formatting formula

    I'm using Excel 2007.

    I want fonts & cell borders to be coloured in red/blue.

    Thanks
  13. Replies
    3
    Views
    138

    Conditional Formatting formula

    Dear All,

    I want to have a formula/VBA Code for my data described as below:

    Col A date (dd/mm/yyyy) with the oldest date being 01/04/2009
    Col B amount due from customers
    Col C name of...
  14. Replies
    0
    Views
    152

    Data Import from MS Word

    Hi All!

    Can u help me to import documents file in Excel from MS Word keeping page size (say A4), margins, layouts and text matters intact as in the Word document?:eeek:
  15. Comparision of Data in 2 Different Files

    Dear All,

    Please guide me how to compare Data in 2 different files so that uncommon data in the 2 files are automatically highlighted. The data relate to Customer Name, Invoive No., Invoice Date,...
  16. Replies
    1
    Views
    123

    Data Formatting

    Dear All,

    I need to write date in dd/mm/yyyy format only. But I receive data mainly in mm/dd/yy format and sometimes in mm/dd/yyyy format.

    Pls help me.

    Thanks in advance.:mad:
  17. Replies
    6
    Views
    279

    Re: VBA Code for Worksheet Formatting

    Dear Mr Poulsom,

    1) Pl explain how to format all 3 sheets (open by default) in any file.

    2) Pl also explain how to hide unwanted columns & rows.

    Thanks in advance.
    Oh!Calcutta:biggrin:
  18. Replies
    6
    Views
    279

    Re: VBA Code for Worksheet Formatting

    Dear patel45

    Thank you!:laugh:
  19. Replies
    6
    Views
    279

    Re: VBA Code for Worksheet Formatting

    Dear Mr. Poulsom,

    Thank you very much for your prompt help.

    Oh!Calcutta
  20. Replies
    6
    Views
    279

    VBA Code for Worksheet Formatting

    Hi all!

    I want to format my worksheets as Cols. A to AZ and Rows 1 to say 3000. Pl help me. I could not locate earlier post(s) on this topic, if any.

    Thanks in advance.:laugh:
  21. Replies
    4
    Views
    7,060

    Indian PAN Format

    Hi All,

    Can anyone help me frame a Data Validation formula for Indian PAN in a column? The data structure is 5 Alphabets 4 numbers and an Alphabet (i.e. field length is 10).

    Thanks in...
  22. Replies
    1
    Views
    203

    Data Formats

    My Financial Data has the following column headings:
    Col A : Shares of xxxx Co
    Col B: No. of Shares
    Col C: Date of investment (dd/mm/yyyy)
    Col D: Amount paid
    Col E: Date of Sale
    Col F: Amount...
  23. Replies
    1
    Views
    182

    Date Format

    Dear All,

    I'm using Excel 2007 for sales data about 2000 rows. The operator is using Invoice date sometimes as MM/DD/YY and sometimes as DD/MM/YY.

    I need to use Invoice date in DD/MM/YYYY...
Results 1 to 23 of 23