| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Trailing Space / Format Question
Hey gang
I have a spreadsheet in Excel 2003 that has values imported from a Crystal report. All the numbers have a trailing space, so I can not format them to show dollar signs, decimals, comma seperators, etc... I have tried to use the TRIM function, then copy/pasteValues only, but the values only paste gives me back the trailing space. Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format numbers in chart datatable | Charts and Charting in Excel | |||
| Time Format Auto Entry AM and PM | Excel Discussion (Misc queries) | |||
| copy conditional format as ACTUAL format | Excel Discussion (Misc queries) | |||
| make a conditional format the default | Excel Discussion (Misc queries) | |||
| format question when open csv file | Excel Discussion (Misc queries) | |||
Threaded Mode
