#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default number to text

how i can change number in text format in excel 2007
30,000 in to thrirty thousand
--
MoinnioM
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,520
Default number to text

Moin, check out responses for your previous query. You *** WILL *** need to
use a macro..and there is no shortcut..

http://www.microsoft.com/office/comm...d-47465f1b5405

If this post helps click Yes
---------------
Jacob Skaria


"moin" wrote:

how i can change number in text format in excel 2007
30,000 in to thrirty thousand
--
MoinnioM

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Formula to change scientific number to regular number or text Compare Values Excel Discussion (Misc queries) 2 August 23rd 07 06:10 PM
Counting a mixed text/number column based on text in another colum Sierra Vista Steve Excel Discussion (Misc queries) 3 December 17th 06 05:30 PM
convert text-format number to number in excel 2000%3f Larry Excel Discussion (Misc queries) 1 July 29th 05 08:18 PM
Why does this fail? =TEXT(RC3,Number)&" / "&TEXT(R32C,Number) =TEXT(RC3,Number)& / &TEXT(R32C,Number Excel Worksheet Functions 2 June 23rd 05 01:02 AM
not able to convert text, or graphic number to regular number in e knutsenk Excel Worksheet Functions 1 April 2nd 05 08:41 AM


All times are GMT +1. The time now is 02:51 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"