Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I want to format a range of cells so that it automatically places the decimal
point as if it were money...i.e. type 123 & have it print 1.23. I want to do this without using the Options....edit which does it for the whole spreadsheet, thus not allowing different types of number formats elsewhere in the spreadsheet. I don't have any negative numbers, and I feel the answer is in the custom number format, but I haven't been able to figure how it works. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Setting print options globally ? | Excel Discussion (Misc queries) | |||
Footer does not print on bottom of document | Excel Discussion (Misc queries) | |||
set the print area print multiple tabs | Excel Discussion (Misc queries) | |||
I want to type a poem and print it | New Users to Excel | |||
Printing - Have to set print area 1 column further than necessary | Excel Discussion (Misc queries) |