Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cells will not change from text format.
Hello, We have a system that builds reports and allows the user to download
them as excel files amongst other formats. Today I opened up the report to be greeted by a lot of the numbers set as text format (bringing up the error flag). Attempting to do =SUM(504:550) just returns a zero. Right clicking the cells and then going to format cells and attempting to set them to general or number doesn't work. If I hold the cursor over the error symbol and then click "convert to number", this works. I'm just wondering what's going on? I'll tell them to do the "convert to number" thing to enable them to do things with the numbers, but some arn't computer literate at all, thus want to steer away from lots of instructions to throw at them. Thank you for any help offered. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cells will not change from text format.
How is the text being segmented into each cell? Are there any extra spaces?
I ran into a problem once before that involved extra spaces and I thought it might be helpful here. How is this information being imported? Has anything changed recently that could be a culprit with your problem? Mark Ivey "NateBuckley" wrote in message ... Hello, We have a system that builds reports and allows the user to download them as excel files amongst other formats. Today I opened up the report to be greeted by a lot of the numbers set as text format (bringing up the error flag). Attempting to do =SUM(504:550) just returns a zero. Right clicking the cells and then going to format cells and attempting to set them to general or number doesn't work. If I hold the cursor over the error symbol and then click "convert to number", this works. I'm just wondering what's going on? I'll tell them to do the "convert to number" thing to enable them to do things with the numbers, but some arn't computer literate at all, thus want to steer away from lots of instructions to throw at them. Thank you for any help offered. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change Date Format to Specific Text Format When Copying | Excel Discussion (Misc queries) | |||
VBA automatically change text format into general format? | Excel Programming | |||
Change number (in text format) to numeric format | Excel Discussion (Misc queries) | |||
Hoe to change text format .126 to number format 0.126 | Excel Discussion (Misc queries) | |||
How do i change numbers in text format to number format? | New Users to Excel |