| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Long # turns into a formula-How do I turn that off?
I have to enter the date in a certain way, yyyymmddhhmm.
I enter 200704301524 into a cell. I save the file in .csv. When I open the file again, the # is changed to a formula, 2.00704E+11 How do I get it to not do that? I have tried saving it as a text, and it still doesn't work. Thanks, Chris |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Long # turns into a formula-How do I turn that off?
You're seeing scientific notation format. You could change the format to:
Format/Cells/Number/Custom 000000000000 In article , Chris wrote: I have to enter the date in a certain way, yyyymmddhhmm. I enter 200704301524 into a cell. I save the file in .csv. When I open the file again, the # is changed to a formula, 2.00704E+11 How do I get it to not do that? I have tried saving it as a text, and it still doesn't work. Thanks, Chris |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Long # turns into a formula-How do I turn that off?
I do that, and save teh file. When I open the file again, it goes back to the
formula. "JE McGimpsey" wrote: You're seeing scientific notation format. You could change the format to: Format/Cells/Number/Custom 000000000000 In article , Chris wrote: I have to enter the date in a certain way, yyyymmddhhmm. I enter 200704301524 into a cell. I save the file in .csv. When I open the file again, the # is changed to a formula, 2.00704E+11 How do I get it to not do that? I have tried saving it as a text, and it still doesn't work. Thanks, Chris |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Long # turns into a formula-How do I turn that off?
Yep.
Excel sees the .csv file and does what it wants with the data. You have a few options: 1. Don't save the file as .csv (use .xls -- a normal workbook) 2. Rename the .csv file to .txt and when you open that file via File|Open, you'll be able to specify the field the way you want (text??). 3. Reapply the number formatting each time you open the .csv file. Chris wrote: I do that, and save teh file. When I open the file again, it goes back to the formula. "JE McGimpsey" wrote: You're seeing scientific notation format. You could change the format to: Format/Cells/Number/Custom 000000000000 In article , Chris wrote: I have to enter the date in a certain way, yyyymmddhhmm. I enter 200704301524 into a cell. I save the file in .csv. When I open the file again, the # is changed to a formula, 2.00704E+11 How do I get it to not do that? I have tried saving it as a text, and it still doesn't work. Thanks, Chris -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Long # turns into a formula-How do I turn that off?
Also enclosing the "number" in single quotes will force it to remain text.
Dave Peterson wrote: Yep. Excel sees the .csv file and does what it wants with the data. You have a few options: 1. Don't save the file as .csv (use .xls -- a normal workbook) 2. Rename the .csv file to .txt and when you open that file via File|Open, you'll be able to specify the field the way you want (text??). 3. Reapply the number formatting each time you open the .csv file. Chris wrote: I do that, and save teh file. When I open the file again, it goes back to the formula. "JE McGimpsey" wrote: You're seeing scientific notation format. You could change the format to: Format/Cells/Number/Custom 000000000000 In article , Chris wrote: I have to enter the date in a certain way, yyyymmddhhmm. I enter 200704301524 into a cell. I save the file in .csv. When I open the file again, the # is changed to a formula, 2.00704E+11 How do I get it to not do that? I have tried saving it as a text, and it still doesn't work. Thanks, Chris |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Long # turns into a formula-How do I turn that off?
But doesn't this add extra characters to each value?
I ended up with '1234' in a cell (including both apostrophes) Bob I wrote: Also enclosing the "number" in single quotes will force it to remain text. Dave Peterson wrote: Yep. Excel sees the .csv file and does what it wants with the data. You have a few options: 1. Don't save the file as .csv (use .xls -- a normal workbook) 2. Rename the .csv file to .txt and when you open that file via File|Open, you'll be able to specify the field the way you want (text??). 3. Reapply the number formatting each time you open the .csv file. Chris wrote: I do that, and save teh file. When I open the file again, it goes back to the formula. "JE McGimpsey" wrote: You're seeing scientific notation format. You could change the format to: Format/Cells/Number/Custom 000000000000 In article , Chris wrote: I have to enter the date in a certain way, yyyymmddhhmm. I enter 200704301524 into a cell. I save the file in .csv. When I open the file again, the # is changed to a formula, 2.00704E+11 How do I get it to not do that? I have tried saving it as a text, and it still doesn't work. Thanks, Chris -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Long # turns into a formula-How do I turn that off?
Put single quote first when you enter it as in
'200704301524 Chris wrote: I have to enter the date in a certain way, yyyymmddhhmm. I enter 200704301524 into a cell. I save the file in .csv. When I open the file again, the # is changed to a formula, 2.00704E+11 How do I get it to not do that? I have tried saving it as a text, and it still doesn't work. Thanks, Chris |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Long # turns into a formula-How do I turn that off?
I have done that too, and the same thing happens. I save the file. Close it
out, and when I reopen it, the formula is back. "Bob I" wrote: Put single quote first when you enter it as in '200704301524 Chris wrote: I have to enter the date in a certain way, yyyymmddhhmm. I enter 200704301524 into a cell. I save the file in .csv. When I open the file again, the # is changed to a formula, 2.00704E+11 How do I get it to not do that? I have tried saving it as a text, and it still doesn't work. Thanks, Chris |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Long # turns into a formula-How do I turn that off?
I'm sorry, missed the CSV and opening it as CSV. Enclose it in quotes.
'200704301524' Chris wrote: I have done that too, and the same thing happens. I save the file. Close it out, and when I reopen it, the formula is back. "Bob I" wrote: Put single quote first when you enter it as in '200704301524 Chris wrote: I have to enter the date in a certain way, yyyymmddhhmm. I enter 200704301524 into a cell. I save the file in .csv. When I open the file again, the # is changed to a formula, 2.00704E+11 How do I get it to not do that? I have tried saving it as a text, and it still doesn't work. Thanks, Chris |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| = sum value turns to text and formula disappears | Excel Worksheet Functions | |||
| My formula is too long, What am I to do? | Excel Discussion (Misc queries) | |||
| the end of long numbers turn to 0s how do i stop that? | New Users to Excel | |||
| formula to long | Excel Discussion (Misc queries) | |||
| How can I create formula that turns a date into the week # in | Excel Discussion (Misc queries) | |||
Hybrid Mode
