Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Text box formatting

Status
Not open for further replies.
SysDupe123

SysDupe123

Technical User
Dec 17, 2003
74
US
In Excel 2003, I have some text boxes for user input on a worksheet. Is there a way to format them so that when someone types in the numbers, it shows up as a percentage in the text box?
 
Sort by date Sort by votes



It's TEXT.

You have to supply whatever you need your TEXT to look like. Usually, this is done with VBA code.

If you need help with code, please pose in VBA Visual Basic for Applications (Microsoft) forum707.

Skip,

[glasses] [red][/red]
[tongue]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

sxschech
  • Locked
  • Question
Pie Chart with linked updatable data table formatting 1
Replies
17
Views
798
combo
combo
jlr123
  • Locked
  • Question
Highlight (any) first text word that is a duplicate
Replies
2
Views
438
SkipVought
S
remeng
  • Locked
  • Question
Power BI - Conditional Formatting on value issue
Replies
0
Views
249
remeng
remeng
caykamanj1966
  • Locked
  • Question
Place a hyperlink on multiple cells with text in Microsoft Excel
Replies
9
Views
610
Andrzejek
Andrzejek
sxschech
  • Locked
  • Question
Excel Conditional Formatting and Non VBA solutions
Replies
17
Views
624
sxschech
sxschech

Part and Inventory Search

Sponsor

Back
Top