Results 1 to 6 of 6
  1. #1
    Star Lounger
    Join Date
    May 2001
    Location
    MIA (takittodahous), Florida, USA
    Posts
    86
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Change Value to Formatted Value (Excel 2002)

    Hi there,

    I'm trying to get a cell to equal it's formatted value instead of it's actual value. I've been away from office products for a while - but the help section is as difficult to wade through as ever, eh?

    Thanks in advance for your advice & help.

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Change Value to Formatted Value (Excel 2002)

    Can you explain what exactly you mean? Does the cell contain a formula and you want it to contain the result from that formula?
    Legare Coleman

  3. #3
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Change Value to Formatted Value (Excel 2002)

    If you mean that the value is formatted to 'n' decimal places and you want the underlying value to be the same, use =Round(argument,n).
    -John ... I float in liquid gardens
    UTC -7ąDS

  4. #4
    Star Lounger
    Join Date
    May 2001
    Location
    MIA (takittodahous), Florida, USA
    Posts
    86
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Change Value to Formatted Value (Excel 2002)

    I'm sorry - I should have given my example:

    The cells contain numeric data ex: 12345678 or 123456

    The format on the cells makes the data look like this ex: 1234 - 5678 or 0012 - 3456

    I would like the cell value changed to the formatted value. I know I could export the data to access, but there must be a better way, eh?

    Thanks again, oh swami's of the Office! ;-]]

  5. #5
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Change Value to Formatted Value (Excel 2002)

    You could format the data by formula and then copy and PasteSpecial values

    If your data is in A1, then use =TEXT(A1,"0000-0000"), and copy and paste the values over the original data.

    Andrew C

  6. #6
    Star Lounger
    Join Date
    May 2001
    Location
    MIA (takittodahous), Florida, USA
    Posts
    86
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Change Value to Formatted Value (Excel 2002)

    Duuh! yep... that'll work. Thank you and I'm sorry my brain is on 'idiot'... I'm dealing with our HR staff here... lmao.

    Thanks again -

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •