Steved

Posts: n/a

Replace Please

Hello from Steve Dee

I would like to please to the following

replace Decimal with colon to make it into time

as an example 9.30 to 9:30 please

if I use . then replace : using 9.30 as an example it will
return 9.03 so I need a formula please.

Thanks for your help in this matter.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
replace command	Jean-Francois	Excel Discussion (Misc queries)	2	January 11th 05 04:43 PM
Replace using wildcards	jeb	Excel Discussion (Misc queries)	6	January 6th 05 03:35 PM
macro to Find Replace in Excel	Nurddin	Excel Discussion (Misc queries)	7	January 3rd 05 04:29 AM
Replace function not working properly in Excel 2000 SP3	rgbytg	Excel Worksheet Functions	5	November 11th 04 03:44 PM
search & replace	joe_may	Excel Worksheet Functions	1	November 8th 04 11:16 PM

All times are GMT +1. The time now is 10:38 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us