ANmarS - Search results

Excel/VBA expert since Sep 1997 (21 years 2 months)

We are moving ...

We are moving to another location, better, faster and more resources .... check it out ANmar.Systems

3 Q & A posts tagged with convert

Sat
Nov 19
2011

Excel formula to convert gram to kilo?

Hi everybody ,

I would like to know if there is a formula to convert grams (example 375 gr) to kilos (0.375)
What is the easiest way to achieve that ?

Thank you very much for your help


Answer

Say grams is in A1, in B1, paste this
=A1/1000

That is all

That would be the easiest way

Saturday 11/19/2011 10:46:13 AM
Sat
Nov 19
2011

How can I convert from pipe delimited txt file to excel file?

Then convert that excel file to rss feed?

Or am I making this more difficult than it needs to be?


Answer

Excel already have Text two Columns wizard, however, you can use this one
http://www.anmars.com/Work/?P=589970000

It is in pure formulas and can be used to extract unlimited columns with certain delimiter

Once you copy and paste the content into column A fill the formulas down to extract them

Saturday 11/19/2011 3:58:51 AM
Wed
Jan 21
2009

How do you convert a sound file to play on a power point?

I'm making a power point and i want a song to play through out the presentation. I tried to apply the song, and it said it needs to be converted to .wav ? Or something like that? Can anyone tell me how to do this PLEASE!!! Thank you in advance :)


Answer

The best one I tried is this one
http://www.download.com/WM-Converter/300…

It is free, try it

VBAXLMan

Wednesday 1/21/2009 12:08:47 PM

Tags

History