If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
How can I format a cell to have the same text with a number
Look he
http://www.cpearson.com/excel/latlong.htm -- Kind regards, Niek Otten Microsoft MVP - Excel "kpt" wrote in message ... |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. |
#3
|
|||
|
|||
How can I format a cell to have the same text with a number
Hi kpt,
Define the custom number format as: 0 "deg/sec" or as: +0 "deg/sec";-0 "deg/sec" depending on what you're after (it's not entirely clear). -- Cheers macropod [MVP - Microsoft Word] "kpt" wrote in message ... 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 | |
Display Modes | |
|
|