Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Format numbers in Textbox
I have a textbox that is linked to a cell. That cell contains currency type
data. How do I set the formatting of the text box to carry over that data and format it with $ and ,'s |
#2
|
|||
|
|||
Text boxes treat everything as text, even when entries appear numeric. So
there is no built-in number formatting option available. -- Jim "stickandrock" wrote in message ... |I have a textbox that is linked to a cell. That cell contains currency type | data. How do I set the formatting of the text box to carry over that data | and format it with $ and ,'s |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Parse text & numbers & format | Excel Worksheet Functions | |||
Using Replace to Format Negative Numbers | Excel Discussion (Misc queries) | |||
Pasting numbers and formulas without pasting format. | Excel Discussion (Misc queries) | |||
Converting numbers to date format from csv files | Excel Discussion (Misc queries) | |||
entering numbers to display a time format | Excel Discussion (Misc queries) |