![]() Another advantage of this feature is the ability to add thousands separators without changing the cell values. Using excel 2007 Isnt there a short cut to add and remove the dollar sign from formulas? Conditional Formatting->Highlight Cell Rules->Less Than in the Home tab as shown in the screenshot below. ![]() Use concat on cell with minus sign and the cell with number 08-18-2017 11:03 AM. So, there is more than one way to remove commas from numbers, or names. ![]() Most Excel users figure out how to lock these references by either toggling through the options with the F4 key or using the $ (dollar sign) symbol in front of the column and/or row references.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |