| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
assume the number I type is in the thousands
I have a spread sheet that is dealing with home prices. As you can guess,
I'm typing a lot of zeros. Instead of typing 300,000 for a home price, is there anyway that I could format a cell so I type 300 and the number pops up as $300,000? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| look up number in column | Excel Worksheet Functions | |||
| convert text-format number to number in excel 2000%3f | Excel Discussion (Misc queries) | |||
| Master invoice number | Excel Worksheet Functions | |||
| Defining a number in a cell by text then subtracting it by the tex | Excel Worksheet Functions | |||
| Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions | |||
Threaded Mode
