Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2005
    Posts
    183

    Unanswered: Convertering cell values

    Formatting a cell's value is often easy enough.

    Right now I have a somewhat trickier assignment. Next to a column with decimal separated values (i.e0,87 3,21 12,03) I need to convert the values to 00:87 03:21 12:03.

    Been trying my way around formatting the cells, and doing isnert specials, but sitll have't worked it out. Any suggestions while I keep trying different ways are much appreciated.

    Cheers, T
    IT squid: networks, servers, firewalls, routers and I dabble a little with SQL-server and Access as well....

  2. #2
    Join Date
    Jan 2009
    Location
    Kerala, India
    Posts
    183
    Try the SUBSTITUTE() Function.

    =(A1,",",":") where A1 is the cell where you have the value 0,87 3,21 12,03
    the result will be 0:87 3:21 12:03 (how you got the value 0,87).

    The result will appear in the Cell where you enter the SUBSTITUTE() Function. The original value will remain where it is.

    You can copy paste the expression down all the rows to covert all values.
    www.MsAccessTips.com (Learn MS-Access Tips & Tricks)
    Learn Advanced MS-Access Programming with sample VBA Code.

    All responses are based on Access 2003/2007

Posting Permissions

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