Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel will not recognize numbers
Hello everyone,
One of my users is having a very peculiar problem occur with their ****tysoft, I mean microsoft, excel 2007. I know this must be surprising since microsoft's products are so user friendly, but really this is no joke. For some reason it's treating all numbers as text. No matter what we've tried to do to change the formatting we can't get this worksheet to recognize numbers as numbers. I've done a work around by just deleting that sheet and starting a new one. In this case there was very little data on the work sheet and so deleting it wasn't that big of an issue. However, this is not an acceptable solution in that there may be a time that comes where a worksheet has a larger amount of data, and simply starting new one would be a lot of work. What happened with this particular worksheet and what needs to be done to get it back on track when it happens again. I've got over 40 users and all of the "little" software problems with Office 2007 are starting to get old. Thank you in advance for you help and patience with this. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel will not recognize numbers
You may use this in addition:
=value(trim(a1)) Eduardo wrote: Hi, are you importing the file ? if yes try in the adjacent column =trim(A1) sometimes there are blank spaces not easy to see Hello everyone, [quoted text clipped - 13 lines] Thank you in advance for you help and patience with this. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import data from Access and doesnt recognize numbers in left func. | Excel Worksheet Functions | |||
Formulas do not recognize numbers | Excel Discussion (Misc queries) | |||
How to format cells to recognize numbers like 1.1.1? | Excel Discussion (Misc queries) | |||
how can excel recognize strikethrough? | Excel Worksheet Functions | |||
Excel recognize "~" | Excel Worksheet Functions |