LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kpt kpt is offline
external usenet poster
 
Posts: 11
Default How can I format a cell to have the same text with a number

I need to format a cell to have deg/sec follow when ever a number is entered.
I found where in custom formatting there is a +/- sign that is automatically
entered when a number is entered. I need it to work like that.
 
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
format date & number within a cell containing text sam Excel Discussion (Misc queries) 2 April 29th 08 02:30 PM
Combining text and cell reference keeping number format RajenRajput1 Excel Discussion (Misc queries) 6 August 23rd 07 05:18 PM
convert a numeric number in text format in another cell? Abhishek Excel Worksheet Functions 2 February 22nd 07 05:44 PM
Format number to display % symbol smaller than onther text in cell [email protected] Excel Discussion (Misc queries) 1 October 11th 06 12:31 AM
16 digit number wont keep alteration unless format cell to text Croc001 Excel Discussion (Misc queries) 3 March 30th 05 09:12 AM


All times are GMT +1. The time now is 02:26 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"