Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
File Download loses Excel features
When I download a file off the mainframe I save it as a text file. When I
open the file I use de-limited to get my columns and re-save in Excel format. However, I cannot use some functions like writing an €œif€ statement. When I type the €œif€ statement it appears just as I have typed it. What do I have to do to gain Excels functionality? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
File Download loses Excel features
Select all the cells, use Format./Number, use General, THEN put in your
if-statements. The cells were formatted as text. Bob Umlas Excel MVP "JHL" wrote: When I download a file off the mainframe I save it as a text file. When I open the file I use de-limited to get my columns and re-save in Excel format. However, I cannot use some functions like writing an €œif€ statement. When I type the €œif€ statement it appears just as I have typed it. What do I have to do to gain Excels functionality? Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
File Download loses Excel features
It sounds as if your cell is formatted as text, so that's why it's not
evaluating the formula. Format the cell as General, and either re-enter your formula, or F2 and enter. -- David Biddulph "JHL" wrote in message ... When I download a file off the mainframe I save it as a text file. When I open the file I use de-limited to get my columns and re-save in Excel format. However, I cannot use some functions like writing an "if" statement. When I type the "if" statement it appears just as I have typed it. What do I have to do to gain Excel's functionality? Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
File Download loses Excel features
Thank you both. That worked.
"David Biddulph" wrote: It sounds as if your cell is formatted as text, so that's why it's not evaluating the formula. Format the cell as General, and either re-enter your formula, or F2 and enter. -- David Biddulph "JHL" wrote in message ... When I download a file off the mainframe I save it as a text file. When I open the file I use de-limited to get my columns and re-save in Excel format. However, I cannot use some functions like writing an "if" statement. When I type the "if" statement it appears just as I have typed it. What do I have to do to gain Excel's functionality? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
File download for Excel | Excel Discussion (Misc queries) | |||
Using excel wizard for file download | Excel Discussion (Misc queries) | |||
download a .csv file to Excel | Excel Discussion (Misc queries) | |||
How can I download a PDF file to Excel | Excel Discussion (Misc queries) | |||
Save & Save As features in file menu of Excel | Excel Discussion (Misc queries) |