| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to add 'ft' to number input in cell - as in 25ft
Can someone help with this in Excel 2007??
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to add 'ft' to number input in cell - as in 25ft
Hi Beth
the same as in earlier versions of Excel FormatCellNumberCustom 0.0 "ft" Set the number of decimal places you want as appropriate. 25 entered in the cell will show as 25.0 ft with the above format. All that is stored is the number 25, which can be used in subsequent calculations. -- Regards Roger Govier "bethgames" wrote in message ... Can someone help with this in Excel 2007?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| input in number form is being multiplied by 1000 when i input. | Excel Discussion (Misc queries) | |||
| Input number in cell and automatically goes to cell where that num | Excel Worksheet Functions | |||
| Formatting to show 0 as first number in a cell when input | Excel Worksheet Functions | |||
| how to input a 12 digit number into a cell | New Users to Excel | |||
| Change color of cell after user has input a number | Excel Discussion (Misc queries) | |||
Linear Mode
