Is it possible to convert any number in text.
For Example if i entered 500 then by any folmula can excel can give output
of five thousend.
--
Ankit Varshney
9210639227
--~--~-~--~~~---~--~~
Visit the blog to download Excel tutorials at
http://www.excel-macros.bl
No file attached can u please send me the shortcuts.
On Fri, Sep 12, 2008 at 12:20 PM, Krishna Kishore <[EMAIL PROTECTED]>wrote:
> Hello
>
> Reddy
>
> Good Morning
>
> Thank you very for providing very useful and handy shortcuts. God bless you
> and your family.
>
> Have a wonderful life.
>
> Ta
I have a spreadsheet with a column of data that contains a date and
time, I want to split the time into a separate column but retain the
format of the time as 24 hour clock.
The reason being is I want to create a histogram using the data
analysis Add-In to show how many items were created between
Thanks for that I have modified all my code and it runs in under 1
second now with no epileptic fits!
On Sep 11, 10:00 pm, jamesdavey <[EMAIL PROTECTED]> wrote:
> For a start, you don't need to activate the sheet to do things to it.
>
> You can write for example:
>
> Sheet1.range("a1").offset
Att: Hitesh Dilipbhai Dhare
Open VBE
Go to View -> Project Explorer
Click on the Sheet name to view its private module
See attached for example
_
"There are known knowns. These are things we know
