#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 390
Default Convert to text

How can I convert 5456 into text.

Thanks.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11,058
Default Convert to text

Place a single quote (apostrophe) in front of it.

If you mean change it into:
Five Thousand Four Hundred Fifty Six
see:

http://support.microsoft.com/default.aspx/kb/213360
--
Gary''s Student - gsnu200860


"MAX" wrote:

How can I convert 5456 into text.

Thanks.

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
How do i convert diagonal text into horizontal text Alexander Excel Worksheet Functions 0 July 15th 08 07:02 PM
Convert a number to Text Tom Excel Discussion (Misc queries) 2 May 22nd 08 09:57 PM
How do I convert a text array to a concatenated text cell? Excel. Vargasjc Excel Worksheet Functions 5 December 20th 06 06:35 PM
how to convert text to value Sally Excel Worksheet Functions 1 July 26th 05 02:43 PM
convert a range of lowercase text to upper text or vice versa jackdaw Excel Worksheet Functions 2 May 16th 05 09:31 PM


All times are GMT +1. The time now is 01:57 PM.

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

About Us

"It's about Microsoft Excel"