Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Is there a way to bulk convert a standard number ( 1,233) to a "numbers as
text" format in an excel column. I can add the apostrophe to the cell...and then add the comma to the resulting text/number...but I have a long column with about 2000 numbers with comma that I must convert to the numbers as text format with the little triangle in the upper left cell corner as follows ( 1,234 ) Can this be done somehow thru formulas or mass cell formatting ? Thanks, Tim R |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
help with formatting a sheet with text and numbers | Excel Worksheet Functions | |||
Formatting from text to numbers | Excel Worksheet Functions | |||
numbers to text with formatting | Excel Discussion (Misc queries) | |||
Formatting Phone Numbers in a Merged Cells... | Excel Discussion (Misc queries) | |||
conditional formatting with numbers and text | Excel Worksheet Functions |