Thread: Convertering cell values
08-01-11, 08:40 #1Registered User
- Join Date
- Oct 2005
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, TIT squid: networks, servers, firewalls, routers and I dabble a little with SQL-server and Access as well....
08-02-11, 10:45 #2Registered User
- Join Date
- Jan 2009
- Kerala, India
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