Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I save formatted cells in excel?
I change the formatting for a cell to "Text" type in "+H" Save the file
abc.csv When I open the file the cell changes to "#NAME?" and the formatting changes to general. how do I keep the formatting as text? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I save formatted cells in excel?
"JayBird" wrote in message ... I change the formatting for a cell to "Text" type in "+H" Save the file abc.csv When I open the file the cell changes to "#NAME?" and the formatting changes to general. how do I keep the formatting as text? Most formatting cannot be saved in csv files - they're nothing but text. If you need to save formats, you have to save the file in Excel format. File, Save As, change file type to Excel, and you'll see the file extension change from csv to xls. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merging cells in Excel 2003 | Excel Discussion (Misc queries) | |||
copy & paste spreadsheet cells from excel to outlook to excel | Excel Discussion (Misc queries) | |||
Can't save Excel using Save button, | Excel Discussion (Misc queries) | |||
Color Formatted Cells not showing color | Excel Worksheet Functions | |||
How to make empty cells as zero in excel add-ins for SQL Server an | Excel Worksheet Functions |