| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Wrong data format in columns ... What's going on?
I get a sheet of data from a friend to look at ... It wonąt sort!
It looks as if some of the data is text, but some is still in numerical format ... How is this able to be change ... We have found a work-around: if you edit in cell and hit enter it sometimes accepts your data type. However, changing it in FormatCells, does not work. Help! Any ideas would be greatly appreciated ... Thanks Brad.) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| from date format convert to text format is wrong | Excel Discussion (Misc queries) | |||
| columns wrong data | Excel Discussion (Misc queries) | |||
| Adding columns using dates, but getting wrong data | Excel Worksheet Functions | |||
| Format columns if data in Col A | Excel Discussion (Misc queries) | |||
| Exported Data to excel appearing wrong in Columns | Excel Discussion (Misc queries) | |||
Threaded Mode
